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.
