Delete Hidden Named Range
 

Everytime I open a certain Excel file, I get a message saying that I have
links to another spreadsheet. I think these link references may be caused by
a hidden named range. How can I find all of the hidden named ranges in a
spreadsheet and how can I delete the ones that may be causing this? Thanks.

Delete Hidden Named Range
 

Get a copy of Bill Manville's FindLinks addin...

http://www.oaltd.co.uk/MVP/
--
HTH...

Jim Thomlinson


"Scott" wrote:

Everytime I open a certain Excel file, I get a message saying that I have
links to another spreadsheet. I think these link references may be caused by
a hidden named range. How can I find all of the hidden named ranges in a
spreadsheet and how can I delete the ones that may be causing this? Thanks.

Delete Hidden Named Range
 

FYI the named ranges are not really hidden. They are probably sheet level
named ranges as opposed to workbook level named ranges. Check out the
NameManager addin from JK Pieterse at the same link I posted earlier.
--
HTH...

Jim Thomlinson


"Scott" wrote:

Everytime I open a certain Excel file, I get a message saying that I have
links to another spreadsheet. I think these link references may be caused by
a hidden named range. How can I find all of the hidden named ranges in a
spreadsheet and how can I delete the ones that may be causing this? Thanks.

Delete Hidden Named Range
 

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Scott wrote:

Everytime I open a certain Excel file, I get a message saying that I have
links to another spreadsheet. I think these link references may be caused by
a hidden named range. How can I find all of the hidden named ranges in a
spreadsheet and how can I delete the ones that may be causing this? Thanks.

--

Dave Peterson