Thread: Named Ranges
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Named Ranges

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

And if I want to look at names, I'll use Jan Karel Pieterse's (with Charles
Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

And make sure you save the file after you fix it (could it have been that???).

AussieDave wrote:

In a previous version of my workbook, I used named ranges, two of which
I deleted after upgrading the workbook. However, when I send the new
workbook to an overseas office so they can enter the data and return it
to me, the two deleted named ranges are back there - referring to a
local link "C:\Documents and Settings\........". Every time I
delete them, they keep coming back! Any help will save my sanity.
T.I.A.
Aussie Dave


--

Dave Peterson