Named ranges keep becoming invalid?
Hi there. So I have a workbook with several tabs in it, and in each of them, I have a named range called "SHIP" that refers to one single cell with a number in it. Below is a screenshot of the name manager so you can see what I'm working with...
I use them for two things: 1) in each of these tabs, there is a hyperlink to this cell so that I don't have to scroll way down to see it; 2) in another workbook, I have links to pull the value from each of these cells.
This was working without issue for a while. Then, this week, every single morning those links break. The hyperlinks give me a pop-up error saying the reference is invalid, and the data references show a #NAME? error. If I reenter the formulas exactly the same, they work fine, and the named ranges are still in the name manager unchanged. For the links in a separate workbook, it doesn't matter if I have this workbook open already, they still don't work. Actually, one time they worked until I opened the source workbook, then I got a #NAME? error. What the heck is going on?! Did I define the names improperly or something?
(This is Office 365 business version, btw!)
[link] [comments]
Want to read more?
Check out the full article on the original site