Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Redundant Named Ranges Linking to Other Files
I have a large spreadsheet model (passworded as it is held on a networked
file structure) which has evolved over a couple of years. Worksheets have been copied into the file bringing along their baggage, viz named ranges. The result of this is that when I open the file I have to enter a series of passwords as the file accesses all the named ranges in the other passworded files. It is likely that the majority of these ranges are redundant and I feel a compelling need to get rid of both the named ranges and some of the redundant worksheets to make the file more efficient. The problem is that I do not know which named ranges are still performing vital functions and which are not. Ideally what I need is some sort of auditing tool that will, as a minimum, highlight all the cells on all the sheets that contain named ranges in the formulas. Any ideas? -- JohnG |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Redundant Named Ranges Linking to Other Files
hi John,
You can get most if not all of this function (plus a lot more!) from Name Manager: download it from http://www.DecisionModels.com/downloads.htm Charles _________________________________________ UK Cambridge XL Users Conference 29-30 Nov http://www.exceluserconference.com/UKEUC.html "JohnG" wrote in message ... I have a large spreadsheet model (passworded as it is held on a networked file structure) which has evolved over a couple of years. Worksheets have been copied into the file bringing along their baggage, viz named ranges. The result of this is that when I open the file I have to enter a series of passwords as the file accesses all the named ranges in the other passworded files. It is likely that the majority of these ranges are redundant and I feel a compelling need to get rid of both the named ranges and some of the redundant worksheets to make the file more efficient. The problem is that I do not know which named ranges are still performing vital functions and which are not. Ideally what I need is some sort of auditing tool that will, as a minimum, highlight all the cells on all the sheets that contain named ranges in the formulas. Any ideas? -- JohnG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking named ranges | Excel Discussion (Misc queries) | |||
named ranges | Excel Worksheet Functions | |||
Linking to named ranges in another workbook | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions |