Cannot find and delete an old named formula

K

Ken_Hosking

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel 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 a good way for searching for named cells, apart from Command-F or looking in Name>define?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top