Forum Discussion
Solved
Named Ranges
Can a 'Named Range' be removed (deleted) if it has "#REF" under 'Value'? Thank you!!
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.
3 Replies
- OK, I Googled it and yes it can be removed (deleted). I guess a better question would be "If it has that '#REF' under 'Value', does that mean it's not being used and it is ok to remove (delete)it. Thank you, again!!
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!
