| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named range is hidden when using OFFSET() | Excel Discussion (Misc queries) | |||
| How do I delete the name for a named range i no longer require? | Excel Worksheet Functions | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Linear Mode
