Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
one or more invalid names were detected in this work sheet
Every time I start up excel, it appears a warning "one or more invalid names
were detected in the work sheet. those invalid names have been changed to #REF!". What is problem? How to fix it up? Please help me. Thank a lot |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
one or more invalid names were detected in this work sheet
Did this problem start happening when you opened the file in xl2007?
If yes, then maybe you can go back to xl2003 (or your earlier version) and fix the names. Some names that were legal in xl2003 (and below) are no longer valid in xl2007. Huy Hanoi wrote: Every time I start up excel, it appears a warning "one or more invalid names were detected in the work sheet. those invalid names have been changed to #REF!". What is problem? How to fix it up? Please help me. Thank a lot -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
one or more invalid names were detected in this work sheet
Could you have created a startup template with invalid cell references in a
formula or something like that? Check your the help system for your version of Excel about startup templates. "Huy Hanoi" wrote: Every time I start up excel, it appears a warning "one or more invalid names were detected in the work sheet. those invalid names have been changed to #REF!". What is problem? How to fix it up? Please help me. Thank a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to count No .of same names in work sheet | Excel Worksheet Functions | |||
Invalid Names | Links and Linking in Excel | |||
Renamed invalid sheet name | Excel Discussion (Misc queries) | |||
Recognition of crylic test in work sheet names, VB version 9108 | Excel Discussion (Misc queries) | |||
Invalid Range Names | Excel Discussion (Misc queries) |