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

Question

question

Swetha-7970 asked Sep 23, '21 EmilyDu-MSFT edited Sep 27, '21

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

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

office-sharepoint-online office-sharepoint-server-administration office-sharepoint-server-customization

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Swetha-7970 · Sep 23, 2021 at 06:28 PM

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.

0 ·

Answer 1 · 2021-09-23T17:52:34.367Z

sbairu answered Sep 23, '21 Swetha-7970 commented Sep 23, '21

Thanks, @Swetha-7970 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

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Swetha-7970 · Sep 23, 2021 at 06:15 PM

I have full control on the file and the site.

0 ·

sbairu Swetha-7970 · Sep 23, 2021 at 06:22 PM

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

0 ·

Swetha-7970 sbairu · Sep 23, 2021 at 06:26 PM

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

0 ·

image.png (17.7 KiB)

Answer 2 · 2021-09-24T09:08:47.627Z

EmilyDu-MSFT answered Sep 24, '21 EmilyDu-MSFT edited Sep 27, '21

@Swetha-7970

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://docs.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.

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EmilyDu-MSFT · Sep 27, 2021 at 02:18 AM

@Swetha-7970

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.

0 ·

question