I know that there are some formulas like SUMIF that do not work without the source workbook being open, but I am having some fairly basic formulas fail now (Index Match) for the first time and am getting this Status when I dig into the Edit Links options: The workbook has values that refer to other workbooks. To update them, open these source workbooks. First, Why would this be happening? Is there some level of nesting that prevents automatically updating values? If I open the workbook everything updates fine. Then, to try and work around the issue, I went ahead and broke links in the source workbook so it no longer "has values that refer to other workbooks", however it didn't fix my issue still. How do I get around this?
Bookmarks