question

DieterTontsch-4959 avatar image
0 Votes"
DieterTontsch-4959 asked TrThanh-0186 commented

READ-ONLY We opened this workbook read-only from the server WARNING

What might be the reason (or is it by design) that if we open Excel Files from our on-premises SharePoint 2019 we get this waring ribbon saying "READ-ONLY We opened this workbook read-only from the server --> Edit Workbook", while this is not true for a Word or Powerpoint documemnt form the same location.
If I open an Excel from my OneDrive for Business it also does to show this warning.
Both locations are defined as Trusted Locations for all Office Apps via GPO. There is no Vesioning or checkout configured for that SharePoint library in charge, definitely no Require Checkout.

kind regards,
Dieter

office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

emilyhua-msft avatar image emilyhua-msft ·

Is there any update?

0 Votes 0 ·

3 Answers

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

Hi DieterTontsch-4959,

Do all the Excel workbooks from SharePoint or OneDrive for Business opened in read-only mode, or just some specific workbooks has this issue?

Besides, do you open the files from Excel desktop application?

From the side of Office, I would suggest you try the following steps.

  1. When this issue occur with specific workbooks:

    • Make sure these Excel workbooks do not enabled Share Workbook (Legacy).

    • If you have the right to download these workbooks, please download and open them from local computer for a test.

    • Right click the file and choose Properties. If the Read-only attribute is checked, please uncheck it and select OK. Please go to Security tab, ensure you have full control on these file.

    • You may also right click the sheet name > Move or Copy > Create a copy, then check this issue.

  2. When this issue occur with all workbooks:

    • Open Excel app > File > Options > Trust Center > Trust Center Settings > Protected View > clear three boxes of Protected View at right panel.

    • Update Office to the latest.

    • Repair Office in Control Panel.

  3. Please checkout whether the article below is helpful.

Why did my file open read-only?

Any questions, please let me know.






5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

DieterTontsch-0908 avatar image
0 Votes"
DieterTontsch-0908 answered

Hello,

  • it happens with all workbooks located wherever on our on-premises SharePoint.

  • we open the workbooks with Excel Desktop app, but not from the app, we choose open with Excel from the Browser

  • If I open the same workbook from OneDrive, synched from my on-prem SharePoint, it does open without this warning

  • it happens to the copy of the workbook too

  • for the downloaded copy the issue does not occur, read-only attribute is not checked.

  • our sharepoint on-prem url is present in Trusted Locations. But it might be wrong? The SharePoint URL in trusted locations ist like https:/spnt.m*g.de/. The URL for the file sin charge is like https://spnt.mg.de/mx/it/documents/myworkbook.xlsx. is .../mx/it/ considered as beeing a subfolder from the GPO piont of view? It should, because if I try to add https://spnt.m****g.de/mx/it/ it says, this location is already in place.

15705-image.png

But I must say, none of th eabove suggested ppoints does solve my issue :(

kind regards,
Dieter



image.png (80.1 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

TrThanh-0186 avatar image
0 Votes"
TrThanh-0186 answered TrThanh-0186 commented

Can anyone help , I open files from Team with Excel application and get an error , All my files !
174689-image.png



image.png (13.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

TrThanh-0186 avatar image TrThanh-0186 ·

Open in desktop app
174756-image.png



0 Votes 0 ·
image.png (13.8 KiB)