Forum Discussion
Named Ranges
If a defined name evaluates to #REF!, the range that it refers to does not exist anymore, for example because it has been deleted. Unfortunately there is no way to reconstruct what it originally referred to, so you might as well delete those names.
It is quite possible, however, that some of those names are still being used in cell formulas, data validation or conditional formatting. If so, those won't work as intended, whether you delete the defined name or not. So you may want to search for those names before you delete them.
If a defined name evaluates to #REF!, the range that it refers to does not exist anymore, for example because it has been deleted. Unfortunately there is no way to reconstruct what it originally referred to, so you might as well delete those names.
It is quite possible, however, that some of those names are still being used in cell formulas, data validation or conditional formatting. If so, those won't work as intended, whether you delete the defined name or not. So you may want to search for those names before you delete them.
- Thank you! I've decided to create a backup of this particular workbook and store it elsewhere and then delete the Named Ranges one by one until I discover any unwanted repercusions. But, thank you again!