
Hello,
Good day to you!
Thank you for reaching out to Microsoft Community!
For the information you provided, I wanted to know that the Excel file’s edit or view-only mode depends on the user’s permissions, not the device. You need to configure user-specific sharing settings in OneDrive/SharePoint.
But I will suggest some workarounds you can try:
1. Share files from OneDrive or SharePoint:
- Open the Excel app on your iPhone and locate the shared file (e.g., via File > Open > Shared)
- Shared files from OneDrive or SharePoint may open in Protected View (read-only by default). Avoid tapping Enable Editing to stay in read-only mode.
2. Using "Mark as Final" to Set Read-Only:
If you own the file, adjust permissions:
- Open the file in Excel for Windows or Mac.
- Click File > Info > Protect Workbook.
- Select Mark as Final or Restrict Editing.
- Save the file and upload it back to OneDrive or SharePoint.
Please understand that our initial response does not always resolve the issue immediately. If these steps don’t resolve the issue, feel free to reply, and I am still here to help figure out how to best help you.
Thank you for your cooperation.
Best Regards,
Tina L - MSFT | Microsoft Community Support Specialist