Cannot rid of a formula in a named cell,cannot find the named cell

[Ken_Hosking]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am re-posting this question as I have had no replies but the problem continues:

I have recently saved a workbook as a new file, under a new name. Every time I save the file I get the following message:

"A formula in a cell (Name: Telecom) could not be converted because it contains a function that is not available in the file format to which you are saving."

When I first saved the file there were several named cells identified that I was able to find and delete, and this last one (Telecom) has been deleted using the name define list but the message continues. I have tried using Command-F, and inserting "Telecom" on each sheet for formulas, values and comments but the name cannot be found.

The old spreadsheet from which I did the "save-as" does not have this problem, and neither do several previous versions.

Is there any way for searching for named cells, apart from Command-F or looking in Name>define?

 

[Bob Greenblatt]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel I am re-posting this question as I have had no replies but the
problem continues:

I have recently saved a workbook as a new file, under a new name. Every
time I save the file I get the following message:

"A formula in a cell (Name: Telecom) could not be converted because it
contains a function that is not available in the file format to which
you are saving."

When I first saved the file there were several named cells identified
that I was able to find and delete, and this last one (Telecom) has been
deleted using the name define list but the message continues. I have
tried using Command-F, and inserting "Telecom" on each sheet for
formulas, values and comments but the name cannot be found.

The old spreadsheet from which I did the "save-as" does not have this
problem, and neither do several previous versions.

Is there any way for searching for named cells, apart from Command-F or
looking in Name>define?

What if you add a sheet to the workbook, and then look in defined names
in the new balnk sheet. Is Telecom there?

 

[Ken_Hosking]

What if you add a sheet to the workbook, and then look in defined names

> in the new balnk sheet. Is Telecom there?
>

Hi Bob, thanks for responding.
I inserted a new worksheet, went to insert>name>define and there was no Telecom there.
Regards, Ken