Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
assigned cell names
I hav assigned cell names that I do not use anymore. Each time I now save an
existing Excel 2007 file (that inherited these names from the past) in compatibility mode, Excel 2007 gives me a warning about these names being linked to other workbooks which annoys me. How can I find and remove these fixed cell names? Help much appreciated, Texas Tonie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
assigned cell names
Get hold of Jan Karel Pieterse's NameManager addin,
http://www.jkp-ads.com/Download.asp, then run it with that workbook and you will see all the linked files easily. You can delete them from NameManager. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Texas Tonie" wrote in message ... I hav assigned cell names that I do not use anymore. Each time I now save an existing Excel 2007 file (that inherited these names from the past) in compatibility mode, Excel 2007 gives me a warning about these names being linked to other workbooks which annoys me. How can I find and remove these fixed cell names? Help much appreciated, Texas Tonie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro assigned to a button | Excel Discussion (Misc queries) | |||
Macro Assigned to a Button | Excel Discussion (Misc queries) | |||
how to retrieve current values assigned for names used in EXCEL? | Excel Discussion (Misc queries) | |||
Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
fourmla with result no less than assigned value | Excel Worksheet Functions |