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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook meeting location auto prompts with a suggestion list - need to disable 0
Duplicate pst, or is it? 1
Need Help with Macro Security 1
Named range error 0
Excel 2007 - How to get cell referrences from dates in combobox 3
Can't seem to delete all images from a Word Doc 2
Problem with named range for a large spreadsheet in Excel 2007 0
Importing named range from another workbook 5

Top