ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   assigned cell names (https://www.excelbanter.com/excel-discussion-misc-queries/151719-assigned-cell-names.html)

Texas Tonie[_2_]

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

Bob Phillips

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