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