A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi @Xiong, Chong [External/TBD],
Thank you for posting your question in the Microsoft Q&A forum.
Since you have tried all the steps you listed, could you provide me with more detailed information so I can understand the situation clearly and provide guidance. I greatly appreciate your understanding and cooperation.
- Where is the file stored (OneDrive/SharePoint/Teams/local device)?
- How was it shared? Which sharing link type is used (Specific people, People in your org, or Anyone with the link)? Is it shared View or Edit permission?
- Who is the owner of this file? Are the owner and the user in the same tenant or one of them is external from the other one?
- You said you "found a work around but only with the web version". If you open in Excel web app, do you see any banner like "This workbook contains a permissions policy" or a Sensitivity label?
In the meantime, you can check these articles to see if the issue falls into one of the situations listed there:
- Open a file that has restricted permissions - Microsoft Support
- Access Denied or You need permission errors in SharePoint Online and OneDrive - SharePoint | Micros…
Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.
Thank you for your understanding and cooperation. I'm looking forward to your reply.