Deleting named ranges in Excel

[tractorvix]

Hi folks,

just a quick question. I've got a workbook that contains hundreds of named ranges that refer to other workbooks, which are not linked in any way to the current data (refers to sheets for 2001 etc!).
Just want to check that I'm ok to delete them and that the named ranges would still be there in the workbook that the data refers to.

Basically I don't want to delete all the named ranges, then need one of these old workbooks and find that the data isn't available because I've deleted the named range in another workbook.

Hope this makes sense!

TV

 

[xlbo]

named ranges are workbook (even worksheet) specific

If you delete them in 1 file it should not affect the other file

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Hi,

Not directly related to your question...

"...refers to sheets for 2001 ..."

FYI, this raises a RED FLAG for me; SIMILAR data in a workbook that is segmented into separate locations (sheets). This is not a best and accepted design strategy and it consequently, causes problems for data analysis and reporting, rendering the plethora of Excel's analysis and reporting features nearly worthless, or at best, severely limited.

It's probably too late to scrap this workbook and design a brand new one. But, keep in mind for new projects, that you will be MILES ahead in every way, to have one or more CONSOLIDATED DATA SOURCE(S), rather than one for each day, week, month, year, employee, department, region, product, program, customer, client -- whatever.

My two cents; no extra charge. ;-)

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}