•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Share permissions keep changing, how can I stop it?
Our take
If you're experiencing constant changes to share permissions in your Excel file, it can be frustrating, especially when collaborating with external users. To maintain your desired settings and prevent unauthorized changes, ensure you’re adjusting the file's sharing options correctly. Start by setting the appropriate permissions in the Share settings, then save your file in a compatible format to lock in those changes. If the permissions are still reverting, consider checking for updates or consulting Excel’s support resources for a more stable solution.
I have an excel file that has to be shared with people outside my organization. When I save on excel it changes the permissions and the people outside of my organization lose access. How do I reserict that from happening?
I would like to set it to this:
But it continually reverts to this:
How do I set it to not change from my choice?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Modifying Shared Excel File Owner/AuthorVersions of this question exist but I can’t find an answer that matches with what I am trying to accomplish. There is a shared excel file in Teams that my company uses. The author of the file no longer works for the company but current leadership is trying to restrict access to it (and most likely delete it all together) as it is interfering with adoption of a system that has replaced it. I know who the owner is and they retired from the company over a year ago. How can we go about granting someone the ability to restrict access to it? submitted by /u/jacb415 [link] [comments]
- 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]
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#rows.com#financial modeling with spreadsheets#share permissions#excel file#change permissions#organization#access#restrict access#saving issue#external sharing#permission settings#permission management#file sharing#Excel permissions#file access#online sharing#permission changes