•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Problem with M365 and workbook links
Our take
If you're facing issues with workbook links in Microsoft 365 when moving Excel templates within SharePoint, you're not alone. Many users encounter #REF! errors when internal links update to reflect new file locations. To maintain a consistent connection to your "User List," consider exploring absolute paths or specific link formats. Additionally, review SharePoint and Excel settings that may help preserve source links. Since your users only utilize Excel Online, it’s essential to find solutions that ensure your template remains functional without breaking these crucial connections.
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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- 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]
- Document Control -- Sharepoint and ExcelHi, I'm working on documents that contain either an embedded Excel file in a docx or the document record has a docx and an xlsx individually. For some reason, when we update calculations in the Excel file, the calculations don't "stay" in that Excel doc, if you click on the Fx it will say the link is Sharepoint!My file path! and then the calculation. Which does no one any good because only I have access to my Sharepoint and these files are accessed by dozens. We've tried everything to remove the Sharepoint reference in one xlsx and as soon as you save, it pops right back in there. submitted by /u/Roemeosmom [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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#rows.com#workflow automation#financial modeling with spreadsheets#M365#SharePoint#workbook links#Excel Online#Excel template#document library#User List#internal workbook links##REF! errors#absolute paths#source links#link format