SharePoint references won't update
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Hyperlink does not update when manually changing the date within the URLI have a hyperlink to a web site that is 425-450 characters depending on the account. I have issues. The dates inside the URL change based on month so I cannot hard code the URL in the cell, even though this gets around the function's 255 character limitation when I click on the link. I hard coded the date to April in the URL and it worked, giving me the April data webpage. However, I then did a find/replace to change the date parameters to March dates then clicked on the link, I still got the April data webpage, even though the URL in the Excel cell had March dates. If I choose to hard coded URL and find/replace the dates, how can I make the URL in the Excel cell update to the new date parameters? The webpage did update to March when I clicked on the cell then pressed F2 then click on the link, but I don't want to have to do that for 300 lines. Or, can I use Power Query to help me still use the Hyperlink function, so that the cell only displays the Account number and still work on the ridiculously long URLs? submitted by /u/magickrhythm [link] [comments]
- I need a way to combine multiple workbooks to use in a pivot table that can be refreshed through sharepoint.I have 5 spreadsheets in a folder on sharepoint and one on a separate folder in the same team site. These track contacts made by clients. Each workbook is for a LGA (location) and have the same structure. they have a sheet for each month and a table for that month. I initially struggled to use the Sharepoint Folder to combine these so created queries in Power Query. for each workbook I created a query which combined the 12 tables and then created a query which appended them. I was able to put this in a workbook and a pivot table to summarise where we were up to. it worked really well. the permissions were set using organisational account. this lasted about a day and now I cannot refresh it. I can refresh in the power query editor but not in the spreadsheet. I have opened it in the desktop version and also the same problem. I am now getting errors about legacy connections. I then tried the Sharepoint folder which finally worked but seem I can combine the January tables for the five spreadsheets but then I would need to do the same for each month. I would love any suggestions for this to consistently work and refresh from our sharepoint site (excel online). submitted by /u/Eastern_Echidna5680 [link] [comments]