Delete Hidden Named Range

S

Scott

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.
 
J

Jim Thomlinson

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.
 
Top