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 |
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 |
All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com