•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why is my SharePoint file not opening the latest version for the user?
Our take
When encountering issues with SharePoint files not opening the latest version, several factors may be at play. In collaborative environments, changes can be overwritten or remain unsynchronized due to multiple users accessing the same document. It’s essential to ensure that all users are accessing the most current version, which can be affected by browser cache or hidden instances of the file.
We have a couple of linked shared SharePoint excel trackers. I was asked to make some changes ( new list dropdowns, update a formula). I would make the changes, save, and users kept complaining about things being broken, cannot update links messages etc.
So today I pulled the files offline, fixed everything, locked with password (sheet and workbook), and locked the ranges.
I archived the original files and replaced them with my local version. Then I asked the user to open it, bam old version, autosaves over my file. Replaced again. asked them to right click from the online folder to open, old version. click directly on SharePoint link to open in browser, old version. In the end I was so annoyed I renamed the files.
Obviously my prev changes were getting partially or wholly overwritten by other's files, but I am not sure what was happening today. How do you ensure to open the latest version of the file? Did they possibly have a hidden version open in a browser or something that was affecting the opened file?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How do you handle version control when multiple people touch the same Excel file?My team has a shared Excel file on SharePoint that three of us need to update throughout the week. Nothing crazy, just sales forecasts and pipeline data. The problem is we keep overwriting each other's changes accidentally. One person opens it, forgets to close, someone else saves over their work. We tried naming conventions like v2 and v3 but that got messy fast. I know co-authoring exists but sometimes people just don't refresh or they open the desktop version while someone is in the browser. What systems or workflows actually work for keeping things straight without a dedicated data person? Curious if others have found a simple method that doesn't require everyone becoming an Excel expert. submitted by /u/Southwesterhunter [link] [comments]
- SharePoint references won't updateHi 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 https://preview.redd.it/rfca88yh3ltg1.png?width=1088&format=png&auto=webp&s=067ff28653d6b6a502da71d9f8e471d805cb965a 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! submitted by /u/wackywizardz [link] [comments]
- Problem with M365 and workbook linksHi, I have a document library on SharePoint where I've created an Excel template file. This template contains internal workbook links pointing to a "parent" file called "User List" (located in the same library). When I copy or move the template to another folder (still within the same SharePoint site), the links automatically update to the new location and break. They no longer point to the original "User List" file, causing #REF! errors. Is there a way to "lock" or prevent Excel from modifying these links when the template is copied/moved? For example: Using absolute paths or a specific link format? SharePoint/Excel settings to preserve source links? Converting links to values while keeping them functional? This is critical for my workflow, as the template needs to stay linked to the fixed "User List" file regardless of its own location. My users will only use Excel Online (no desktop app), so Power Query won't work... Thanks for any advice! submitted by /u/MattyKingz [link] [comments]
- SharePoint document library - how to mantain fixed workbook links when i move/copy an Excel file on another folder?Hi, I have a document library on SharePoint where I've created an Excel template file. This template contains internal workbook links pointing to a "parent" file called "User List" (located in the same library). When I copy or move the template to another folder (still within the same SharePoint site), the links automatically update to the new location and break. They no longer point to the original "User List" file, causing #REF! errors. Is there a way to "lock" or prevent Excel from modifying these links when the template is copied/moved? For example: Using absolute paths or a specific link format? SharePoint/Excel settings to preserve source links? Converting links to values while keeping them functional? This is critical for my workflow, as the template needs to stay linked to the fixed "User List" file regardless of its own location. My users will only use Excel Online (no desktop app), so Power Query won't work... Thanks for any advice! submitted by /u/MattyKingz [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#rows.com#AI formula generation techniques#formula generator#natural language processing for spreadsheets#generative AI for data analysis#SharePoint#file#Excel#version#tracker#dropdown#formula#offline#password#ranges#archived