#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro assigned to a button Sadcrab Excel Discussion (Misc queries) 12 December 8th 06 11:16 PM
Macro Assigned to a Button zephyr Excel Discussion (Misc queries) 1 October 25th 06 03:33 PM
how to retrieve current values assigned for names used in EXCEL? yrk Excel Discussion (Misc queries) 3 June 10th 05 08:22 PM
Color a cell and a value is automatically assigned to that color. Bossi Excel Worksheet Functions 0 May 3rd 05 05:45 AM
fourmla with result no less than assigned value Jane Excel Worksheet Functions 1 January 13th 05 07:16 AM


All times are GMT +1. The time now is 08:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"