SharePoint - Change default file opening in desktop/online office?

Question

Hello,

I need to set the default file opening settings in SharePoint. When you open Excel, it always asks if you want to open it in the Excel desktop. There's a checkbox so he doesn't ask again and it works.

The problem is that after restarting, it asks again. This is probably related to the default settings for opening files that can be changed in SharePoint. However, the setup is extremely extensive and I can't find it there.

Please help.

Thank you

Answer 1

Hi MichalRama,

Thank you for querying in this forum.

From your description, it seems that you want to change the default open settings for the files in SharePoint Online. And you don’t want to show the alert to let you open it in client.

May I know if my understanding is right? If so, we’d suggest you go to Settings > Library settings > Advanced settings > select Open in the browser under Default open behavior for browser enabled documents.

For your reference: How to default Office files to open in the native app from SharePoint and OneDrive - SharePoint Maven

***Disclaimer:***Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

And we have also tested it on our side, we selected this option and it opened files in the browser by default.

If the scenario above is not consistent with yours, may I know if you encountered the alert below?

If so, we have tested it on our side with Microsoft Edge and it will appear every time when we open a file. However, per our test, it will not appear in Chrome. You can change another browser to check if the same problem will occur.

If the scenario above is not consistent with yours, could you provide the screenshot of “it always asks if you want to open it in the Excel desktop”?

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Best Regards,

Sukie

Answer 2

May I know if my understanding is right? If so, we’d suggest you go to Settings > Library settings > Advanced settings > select Open in the browser under Default open behavior for browser enabled documents.

For your reference: How to default Office files to open in the native app from SharePoint and OneDrive - SharePoint Maven

Hello,

Yes, I was able to set it up for a specific library, but I couldn't find how to set it up for the whole SharePoint. And I found a solution on the same page, you just overtook me.

Anyway, thank you.