View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Problem with formula in cell

Why not save in the normal file format for the version of excel you are
using.

Look in Tools=Options=Transition tab and the first entry is where you
select the default format for saving.

Choose "Microsoft Excel Workbook" from the dropdown would be my
recommendation.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could not be
converted because it contains a function that is not available in the file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not have this
referenced in a cell on the CO3POS worksheet. How can I resolve this?