question

G99 avatar image
0 Votes"
G99 asked EchoDu-MSFT commented

Open links to Office files in native app rather than browser- SharePoint Online

Hi

I have a user who has created links to Excel (in pages), when they click the link the file opens in browser.

I have already activated the site collection feature for that site and when a user clicks a document that opens in the Excel App and not the browser - so that works.

The issue is, when a user creates a link to that same file, the link on the page when clicked opens the same document in the browser, is there a way around this, the Site Pages library does not have the option Opening Documents in the Browser setting to "Open in the client application"

office-sharepoint-online
· 2
5 |1600 characters needed characters left characters exceeded

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

Hi @G99 ,

Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.

Have a nice day!

0 Votes 0 ·

Hi @G99 ,

Can you tell me whether your issue has been resolved or have any update?

I am looking forward to your reply.

0 Votes 0 ·
EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT edited

Hello @G99 ,

By design, when the document link is added to the page, the document cannot be opened in the client application.

The Site collection feature "Open Documents in Client Applications by Default" works in the Document Libraries.

You can could open file link in client application using URL schema:

79899-url.png

79909-url3.png

Thanks,
Echo Du

====================== Updated Answer ======================

Hi @G99 ,

Yes, From a link only supports http/https link or email address.

You can try the following solution:

1.Go to the Documents library, select the specified excel file and click on "Copy link"

80408-3.png

2.On the Link copied panel, click on Copy button

80409-4.png

3.Go to the page and Edit it

4.On the Quick links web part, click "+ Add links", select "Form a link" option, paste the link to textbox. Then, delete the Id information in the link.

80455-5.png

5.On the Quick links panel, you can can customize thumbnail

80521-6.png

6.Republish page

7.After doing the above operations, when you click on the excel document link on the page, you will be prompted “Do you want to open .xlsx from tenent.sharepoint.com?". Please click on Open button

80410-7.png

8.If the Microsoft Excel Warning Box dispalys, please click on Yes button.

80531-8.png

80447-9.png

Thanks,
Echo Du

===================== Updated Answer =======================

Hi @G99 ,

By design, in Chrome, cannot open the document link located on the SharePoint pages directly in Client application.

Indeed, in Chrome, documents can only be opend in the Client application through downloading.

In Chrome, you can only open excel files in the Client application by entering the following url in the browser:

Note:
This link is not applicable to the SharePoint pages, it only works in the browser.

80597-chrome.png

80641-excel.png

Thanks,
Echo Du
====================
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.



url.png (221.4 KiB)
url3.png (10.2 KiB)
3.png (37.3 KiB)
4.png (10.8 KiB)
5.png (31.9 KiB)
6.png (16.7 KiB)
7.png (239.0 KiB)
8.png (34.8 KiB)
9.png (36.8 KiB)
chrome.png (169.6 KiB)
excel.png (34.6 KiB)
5 |1600 characters needed characters left characters exceeded

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

G99 avatar image
0 Votes"
G99 answered EchoDu-MSFT commented

Hello @EchoDu-MSFT
I had already tried that having found the info online, but when I go to paste the link "From a link" option, I get the following error:

Enter a link from a website (https:// or http://) or email address (mailto:)

· 1
5 |1600 characters needed characters left characters exceeded

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

Hi @G99 ,

I have updated answer under initial My Answer. Hope this can help you to solve issue.

Have a nice day!

Thanks,
Echo Du
=================
You can directly click “Comment” option under “My Answered” to put forward your opinions and thoughts about solution that I propose.


0 Votes 0 ·
G99 avatar image
0 Votes"
G99 answered EchoDu-MSFT commented

Hello @EchoDu-MSFT

I have tried this too, prior to logging this, sorry I should have mentioned. This process works fine but only in Edge, it does not behave this way in Chrome or another browser, rather it downloads the file without prompt
again this is not what the users are expecting, and by default Chrome is the default browser in the org. Any other suggestions?

· 1
5 |1600 characters needed characters left characters exceeded

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

Hi @G99 ,

Thanks for you reply.

I have updated answer under initial My Answer.

Thanks,
Echo Du
=================
You can directly click “Comment” option under “My Answered” to put forward your opinions and thoughts about solution that I propose.

0 Votes 0 ·
G99 avatar image
0 Votes"
G99 answered EchoDu-MSFT commented

Hello @EchoDu-MSFT

I did not get an alert that you had responded, afraid it doesn't work - when i paste the following as a link on a page:

ms-excel:ofe|u|https://Org.sharepoint.com/:x:/r/sites/SPSITE/DocLib/Folder/Folder/Link%filename.xlsx

I get the following error:
Enter a link from a website (https:// or http://) or email address (mailto:)

If i paste your suggested in Chrome, of course that works, and opens the attachment in client version of Excel. but the issue has always been allowing a user to click a link in SP and for the file to open in the client version of Excel, be it they are using Chrome or Edge?
Is this not possible?

· 3
5 |1600 characters needed characters left characters exceeded

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

Hi @G99 ,

In my testing, I did not have a similar error in Google, IE and Edge.

81332-2.png

81343-3.png

If you want users can open the excel files that located on the page directly in the Excel client application. In my research and testing, only Edge can be implemented, and Google does not support it.

Thanks,
Echo Du

0 Votes 0 ·
2.png (393.3 KiB)
3.png (44.5 KiB)
G99 avatar image G99 EchoDu-MSFT ·

Hi @EchoDu-MSFT
i get the error when I attempt to set the link in a SharePoint page- not when I copy and paste the link in a browser.
These are my steps
I edit a quick link on a SharePoint page - I click change - I click 'From a link" - I paste in:

ms-excel:ofe|u|https://Org.sharepoint.com/:x:/r/sites/SPSITE/DocLib/Folder/Folder/Link%filename.xlsx

The error is displayed under the "From a link" box, I hope you understand from the steps I have mentioned
81460-excelerror.jpg


0 Votes 0 ·
excelerror.jpg (54.3 KiB)

Hi @G99 ,

The Quick Links webpart does not support "ms-excel:ofe|u|" .

Thanks,
Echo Du

0 Votes 0 ·