| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula in cell
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with formula in cell
Microsoft Excel Workbook is already selected in the Transition tab.
I do not have a ResetSheet formula. It is a macro in module1. Why would Excel think it's a formula in a cell? "Tom Ogilvy" wrote: 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with formula in cell
If you take it out or comment it out (including the declaration), do you
still get the message? -- Regards, Tom Ogilvy "RW" wrote in message ... Microsoft Excel Workbook is already selected in the Transition tab. I do not have a ResetSheet formula. It is a macro in module1. Why would Excel think it's a formula in a cell? "Tom Ogilvy" wrote: 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with formula in cell
I commented it out and I still get the message.
I also tried changing the name of the macro to ResetSheet2 and I still got the message with the original name (ResetSheet) This is very frustrating. "Tom Ogilvy" wrote: If you take it out or comment it out (including the declaration), do you still get the message? -- Regards, Tom Ogilvy "RW" wrote in message ... Microsoft Excel Workbook is already selected in the Transition tab. I do not have a ResetSheet formula. It is a macro in module1. Why would Excel think it's a formula in a cell? "Tom Ogilvy" wrote: 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with formula in cell
Sure you don't have a hidden sheet named ResetSheet. Maybe an Excel4 macro
sheet? Try running code like Sub ShowAllSheetsandNames() Dim sh as Object, nm as Object for each sh in ActiveWorkbook.Sheets sh.Visible = xlsheetvisible Next for each nm in Activeworkbook.Names nm.visible = True Next End Sub look at all the sheets and go into Insert=Name=Define and examine all the names. See if they have a strange function in them. -- Regards, Tom Ogilvy "RW" wrote in message ... I commented it out and I still get the message. I also tried changing the name of the macro to ResetSheet2 and I still got the message with the original name (ResetSheet) This is very frustrating. "Tom Ogilvy" wrote: If you take it out or comment it out (including the declaration), do you still get the message? -- Regards, Tom Ogilvy "RW" wrote in message ... Microsoft Excel Workbook is already selected in the Transition tab. I do not have a ResetSheet formula. It is a macro in module1. Why would Excel think it's a formula in a cell? "Tom Ogilvy" wrote: 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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with formula in cell
Tom,
Thanks for providing the code to look for invisible sheets - none existed. I also checked Insert=Name=Define on each sheet and did not see anything named ResetSheet. Is there anything else I can look for? "Tom Ogilvy" wrote: Sure you don't have a hidden sheet named ResetSheet. Maybe an Excel4 macro sheet? Try running code like Sub ShowAllSheetsandNames() Dim sh as Object, nm as Object for each sh in ActiveWorkbook.Sheets sh.Visible = xlsheetvisible Next for each nm in Activeworkbook.Names nm.visible = True Next End Sub look at all the sheets and go into Insert=Name=Define and examine all the names. See if they have a strange function in them. -- Regards, Tom Ogilvy "RW" wrote in message ... I commented it out and I still get the message. I also tried changing the name of the macro to ResetSheet2 and I still got the message with the original name (ResetSheet) This is very frustrating. "Tom Ogilvy" wrote: If you take it out or comment it out (including the declaration), do you still get the message? -- Regards, Tom Ogilvy "RW" wrote in message ... Microsoft Excel Workbook is already selected in the Transition tab. I do not have a ResetSheet formula. It is a macro in module1. Why would Excel think it's a formula in a cell? "Tom Ogilvy" wrote: 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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with formula in cell
Nothing comes to mind.
-- Regards, Tom Ogilvy "RW" wrote in message ... Tom, Thanks for providing the code to look for invisible sheets - none existed. I also checked Insert=Name=Define on each sheet and did not see anything named ResetSheet. Is there anything else I can look for? "Tom Ogilvy" wrote: Sure you don't have a hidden sheet named ResetSheet. Maybe an Excel4 macro sheet? Try running code like Sub ShowAllSheetsandNames() Dim sh as Object, nm as Object for each sh in ActiveWorkbook.Sheets sh.Visible = xlsheetvisible Next for each nm in Activeworkbook.Names nm.visible = True Next End Sub look at all the sheets and go into Insert=Name=Define and examine all the names. See if they have a strange function in them. -- Regards, Tom Ogilvy "RW" wrote in message ... I commented it out and I still get the message. I also tried changing the name of the macro to ResetSheet2 and I still got the message with the original name (ResetSheet) This is very frustrating. "Tom Ogilvy" wrote: If you take it out or comment it out (including the declaration), do you still get the message? -- Regards, Tom Ogilvy "RW" wrote in message ... Microsoft Excel Workbook is already selected in the Transition tab. I do not have a ResetSheet formula. It is a macro in module1. Why would Excel think it's a formula in a cell? "Tom Ogilvy" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell reference formula problem | Excel Discussion (Misc queries) | |||
| Problem with formula showing in cell | Excel Worksheet Functions | |||
| Problem After Inserting Cell Formula | Excel Discussion (Misc queries) | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Excel VBA-use variable in active cell formula problem | Excel Programming | |||
Linear Mode
