SOLVED.
Hello everyone,
I have a weird problem. I have had these workbooks set up for months, and they have about a dozen or so sheets in there. On these sheets I am doing tons of v and h lookups, so I name the ranges to make it easier to decipher.
However, just recently whenever I open the file nothing works; I go to the name manager and, for example, for the named range "rankings" it will point to "=[Rankings]#REF!$D$2:$D$33
So I go and delete all these values, reset them, save it, close, open, and the reference errors are back! No reason that I can see... any advice?
I don't have any macros programmed in, and it's being saved as an .xlsx.
This error also occurs no matter if I save the file to the hard drive, network drive, or a USB key.
Bookmarks