SharePoint references won't update
Hi there. My apologies if this has been asked before - I couldn't find a similar post, but I might have missed something.
I have many workbooks that use SharePoint URLs to pull values from separate workbooks. These are just straight up single-cell references, no SUMIFs or anything fancy. Here's an example of one
But for the past week or so, these have suddenly stopped updating reliably when the value in question changes. Notably, I do not get a #REF? error or anything like that. This happens even if the workbook it's referencing is open, and it happens in multiple workbooks where I have these kinds of links. A lot of these are columns where each cell references a cell in a column in another workbook. To fix (or make) these links, I copy the column from the referenced workbook and paste as links in the workbook where the links belong, but several times, when I do this, it turns AutoSave off and won't allow me to turn it back on unless I undo the paste, and instead of all paste options showing in the context menu, it only shows paste normal and paste links (no paste formatting, paste formulas, etc.) What the heck is going on?! Does anyone have any ideas? Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site