Open a document in View mode by default- SharePoint

Question

Is there a way to open Word, Excel, or Powerpoint documents in 'Viewing' mode by default? When I open a document it opens by default in 'Edit' mode. Opening in Edit mode does not accurately display file formatting and headers and footers are not visible.

Ideally, I'd like the document to open in "Viewing" by default to ensure formatting, headers and footers are displayed correctly.

Answer 1

Hi TanyaSPG,

Thanks for sharing updates with us and I really appreciate your effort and your precious time doing those tests. First, please accept my apologize you meet such an issue and I understand it effort on your daily work.

We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation

Regarding to, "If I was to use solution 4, is it possible to also have the ability to 'edit' the document?" if you wish to use Solution 4, and also want user the ability to Edit document as well, the you may use below JSON code in update your column (File column).

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
   "elmType": "a",
   "txtContent": "@currentField",
   "attributes": {
      "target": "_blank",
      "href": "=if(indexOf([$ContentTypeId], '0x0120') >= 0, '?id=' + [$FileRef], @currentWeb + '/_layouts/15/Doc.aspx?sourcedoc='+ [$UniqueId] + '&action=View')"
   }
}

Note: When user click on stored document in SharePoint online document library, it will open in View mode however in the top of document bar have "Edit button" click on it when users want to edit document.

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 2

Hi TanyaSPG,

As per your description, please don’t worry we can work together to narrow down and resolve the situation.

Generally, when we click a Word, Excel or PowerPoint file in SharePoint online and OneDrive for Business or open a sharing link to a Word, Excel or PowerPoint file in your browser, we will open directly into edit mode, allowing you to jump into work faster than ever.

Since you concern, open Office 365 file document “View only” mode by default instead of “Edit “mode.  In my opinion to meet your requirement, here are some solution for you(you can chose).

Solution1:

You can set “Require documents to be checked out before they can be edited“to Yes in Version settings in Library Settings. In this scenario when you and users will open the document (stored in SharePoint online document library) in View/read only mode. See image below for your reference:

Result view:

Solution2:

Also, your needs could be achieved via SharePoint, give yourself read-only permissions. For example, in SharePoint Online, go to site setting> permission - create a new group (read only) - add yourself or other users to this group - after these steps, users will open the document (stored in SharePoint online document library) in read only mode.

Solution3:

If you can open the document at Desktop App (Word, Excel, etc) before uploading at SharePoint. Then you can set the document to open as Read-Only.

Solution4:

You can achieve setting the default to 'View" mode by using SharePoint Column Formatting.

Simply update your column (File column) with the following json and your documents will now open in Preview instead of Edit:

{"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json","elmType": "a","txtContent": "@currentField","attributes": {"target": "_blank","href": "=if(indexOf([$ContentTypeId], '0x0120') >= 0, '?id=' + [$FileRef], [$ServerRedirectedEmbedUrl])"}}

Result preview view:

I appreciate your understanding and stay safe!!

Best regards

Waqas Muhammad

Answer 3

Hi TanyaSPG,

May I know have any updates regarding to this issue? Feel free to post back if you need further assistance.

Best Regards,

Waqas Muhammad

Answer 4

Thank you Charmane for your reply! Sorry for the delayed response (I have been away). I think I will leave it as is because we have others who post their files to the library in whatever format (file type) they'd like. Right now people can click on file name link for Office files to open in Viewing. For PDFs, as a workaround, I tell them to right-click on file and select Open > Open in browser.

Jennifer

Answer 5

Hi TanyaSPG,

Thanks for sharing updates with us and I really appreciate your effort and your precious time doing those tests. First, please accept my apologize you meet such an issue and I understand it effort on your daily work.

 

We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation

 

Regarding to, "If I was to use solution 4, is it possible to also have the ability to 'edit' the document?" if you wish to use Solution 4, and also want user the ability to Edit document as well, the you may use below JSON code in update your column (File column).

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
   "elmType": "a",
   "txtContent": "@currentField",
   "attributes": {
      "target": "_blank",
      "href": "=if(indexOf([$ContentTypeId], '0x0120') >= 0, '?id=' + [$FileRef], @currentWeb + '/_layouts/15/Doc.aspx?sourcedoc='+ [$UniqueId] + '&action=View')"
   }
}

Note: When user click on stored document in SharePoint online document library, it will open in View mode however in the top of document bar have "Edit button" click on it when users want to edit document.

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

In order to prevent users from inadvertently changing the Date Modified for a file, but preserve the ability to Edit and for Autosave be active automatically for when users really do want to make changes, I want this to be the default for all Office (Word, Excel, and PowerPoint) documents. This seems like it achieves exactly the right effect.

How can we make this apply to OneDrive personal and business (or at least OneDrive for Business)? Is that possible, or is this only available to SharePoint Document Libraries? I think of OneDrive for Business as being effectively a SharePoint Document Library, but I'm not sure if it actually works the same under the hood.

We want this to apply to both files stored online and synced to the users' local computers.