When we open excel file in sharepoint it gives alerts saying file opened in read only mode from server.

Question

When we open excel file in sharepoint it gives alerts saying file opened in read only mode from server.

Srikanth 41

How to fix the issue when excel file opens with Read-Only and says file has opened read-only from server.

How to fix Automatic update of links has been disabled issue on excel file which is on SharePoint online

Srikanth 41 Reputation points

2021-09-23T18:28:42.597+00:00

if I hit update or dont update it starts going through dozens of links that it says have errors, and eventually you have to task manager and shut down excel because this error detecting does not end.

2 answers

Your answer

Srikanth 41 Reputation points

2021-09-23T18:28:42.597+00:00

if I hit update or dont update it starts going through dozens of links that it says have errors, and eventually you have to task manager and shut down excel because this error detecting does not end.

Answer 1

Sarat Chandra 601

Thanks, @Srikanth Reaching Q&A forum, could you please send me the screenshot, what permission you have on SharePoint, and also check the permission over the file.

fix Automatic update of links has been disabled: please follow==>https://www.manville.org.uk/software/findlink.htm

Thanks & Regards,
Sarat Chandra

Srikanth 41 Reputation points

2021-09-23T18:15:47.057+00:00

I have full control on the file and the site.
Sarat Chandra 601 Reputation points

2021-09-23T18:22:55.45+00:00

Can you please open the file in File explorer?

https://support.microsoft.com/en-us/office/view-sharepoint-files-in-file-explorer-66b574bb-08b4-46b6-a6a0-435fd98194cc#:~:text=In%20SharePoint%20in%20Microsoft%20365,then%20select%20Open%20with%20Explorer.

Thanks & Regards,
Sarat
Srikanth 41 Reputation points

2021-09-23T18:26:45.317+00:00

Please see the alert below when i open from file explorer.

Answer 2

Emily Du-MSFT 51,836 Microsoft External Staff

@Srikanth

Whether you open excel file stored in the SharePoint Online through excel client application or excel online?

For the first issue, please make sure file is published, approved and checked in.

For the second issue, please according to following tips to narrow down the issue.

1.Whether this error occurs when file is not stored in the SharePoint Online?
2.How do insert these links? Through Insert links or Power Query?
3.Add these links into Trusted Locations then have test.

Reference:
https://learn.microsoft.com/en-US/office/troubleshoot/excel/control-startup-message

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2021-09-27T02:18:01.963+00:00

@Srikanth

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

Share via

When we open excel file in sharepoint it gives alerts saying file opened in read only mode from server.

2 answers

Your answer