I have a couple of files where previously good named ranges stopped working. They appear in name manager with the correct cell reference and value.

However, Go To returns a “Reference isn’t valid” and a simple macro to display the named range value returns a 1004 error.

Things I have tried with no success:

• Deleting the named range and using the same name to setup a new named range resulted in the same errors
• Saving, closing, and reopening resulted in the same errors