Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message refers to Name that can't be found
I have a spreadsheet that another person created. When I go to save the
spreadsheet I get this message: "The name, CLE1, either conflicts with a valid range reference or is invalid for Excel. The name has been replaced with _CLE1. You may still need to manually update any references to this name used in VBA code or as text arguments in functions. You must close and reopen the workbook before these changes take effect." I've looked all through the spreadsheet and find nothing even remotely related to this name. I check macros (none), VBA code, and hidden rows / columns. Nothing. How can I find this bugger? -- Für Elise - Support the Breast Cancer & Heart Foundations |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message refers to Name that can't be found
The "another person" probably created the WB in Excel prior to "2007".
I allow myself to guess that U R using 2007/2010 - and therefor CLE1 is a valid CELL ADDRESS and therefor CANNOT be used as a name for a range Micky "RealGomer" wrote: I have a spreadsheet that another person created. When I go to save the spreadsheet I get this message: "The name, CLE1, either conflicts with a valid range reference or is invalid for Excel. The name has been replaced with _CLE1. You may still need to manually update any references to this name used in VBA code or as text arguments in functions. You must close and reopen the workbook before these changes take effect." I've looked all through the spreadsheet and find nothing even remotely related to this name. I check macros (none), VBA code, and hidden rows / columns. Nothing. How can I find this bugger? -- Für Elise - Support the Breast Cancer & Heart Foundations |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The message EUROTOOL.XLA!fshow TTO Dialog cannot be found | Excel Discussion (Misc queries) | |||
Style 'Percent' not found error message. | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Getting the message: Style 'currency' not found | Excel Discussion (Misc queries) | |||
Lookup returns message box when an exact match is not found | Excel Worksheet Functions |