•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Create a snapshot of a sharepoint file and unlink
Our take
Are you frustrated by the limitations of sharing linked spreadsheets from SharePoint? You’re not alone. Many teams encounter issues when trying to share files that rely on live data connections, leading to errors and confusion. Fortunately, there's a straightforward solution to create a snapshot of your SharePoint file that breaks these links while maintaining its essential functionality. In this guide, we'll explore how to unlink your spreadsheet, ensuring it remains filterable and editable for your audience to provide valuable feedback without encountering access issues.
Hi,
I have a spreadsheet on a SharePoint site that is used by my team. I have a second file on the same SharePoint that pulls some data using a FILTER command. I need to share this second file with people who do not have access to the SharePoint.
I have tried 'save a copy', and save it to a network drive location, and then email the copy to all viewers, but the file still warns that it cannot update links whenever one of those users opens the file. Is there any way to create a version that does not try to update?
The file I send needs to be filterable, and also has editable columns for them to send comments and feedback.
Any ideas?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Why is my SharePoint file not opening the latest version for the user?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? submitted by /u/witchy_cheetah [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]
- 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]
- Idea Company Excel reportingHello, At our company, we have an Excel file on SharePoint with several tabs, one for each department, and these tabs are updated by different people. All the metrics are exported to PDF once a month. However, we're experiencing numerous synchronization issues. Do you know of a better solution? Or another tool? I considered Power BI, but this file contains comments, images, and charts. submitted by /u/pinata43 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#rows.com#natural language processing for spreadsheets#big data management in spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#conversational data analysis#Excel compatibility#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#real-time data collaboration#financial modeling with spreadsheets#automation in spreadsheet workflows#intelligent data visualization#no-code spreadsheet solutions#SharePoint