Excel Hyperlink to open Sharepoint Stored PDF using Adobe Document Cloud

[pgfarquhar]

Hi,

We use Microsoft Excel (desktop version) but our files are stored within SharePoint, note, we have to use the desktop version of excel due to the limitation of the online excel. Any changes sync back up to SharePoint via OneDrive software.

We link supporting documents (PDF files) to this excel document. The PDF files are stored in the same location on SharePoint.

I can open these files directly on SharePoint using the new Adobe Document Cloud program and edit/highlight/annotate as needed. but....

When clicking on the hyperlink from within the Desktop Microsoft Excel file - it opens on the default Chrome browser PDF tool rather than opening it from within Adobe Document Cloud so we can have the ability to edit etc.

Is there a way to direct excel to open these hyperlinks via SharePoint Adobe Document Cloud?

Thanks

Paul

[Christian34726554idyd · Accepted solution]

I asked this question in a Microsoft Forum and got the following workflow.

Append "?web=1" to the weblink.

So if the link is

https://...-my.sharepoint.com/personal/.../Documents/../Test/Testdokument.pdf

append ?web=1

https://...-my.sharepoint.com/personal/.../Documents/../Test/Testdokument.pdf?web=1

This will open the web view.

In the web view you can select Open in Adobe Acrobat.

[ls_rbls]

Hi,

See this guidance from a previous thread with similar inquiry:

https://community.adobe.com/t5/document-cloud-pdf-services/sharepoint-default-open-pdf-option-can-th... 

[Denis34712654dkps]

I'm facing the exact same issue but don't find answer even in the provided link the reply.

I can rephrase the question as follows:
What instruction shall be passed in the hyperlink to open a pdf file strored on the sharepoint in documentcloud.adobe.com?

[ls_rbls]

In which version of Microsoft Windows are you on?

[Denis34712654dkps]

Hi.

Thanks for your interest.

I'm working on Windows 10 Enterprise Edition - Version 21H2

When we click on the sharepoint viewer link on a pdf it opens in the documentcloud.adobe.com interface while when I use the link that is generate by Sharepoint on the same pdf, the file open in the explorer interface...

I wonder what is behind the scene in the hyperlink presented on the sharepoint so that it can be replicated in the hyperlink to get the file opening in the adobe.com interface.

Do you have any idea how to build the hyperlink to achieve the above described objectives?

[Christian34726554idyd]

I didn't have time to test it, but is this, what you are looking for?

https://powerusers.microsoft.com/t5/Building-Flows/Link-to-file-to-open-PDF-in-SharePoint-reader-vie...

[Christian34726554idyd]

sorry for the dead link

here a working one:

https://powerusers.microsoft.com/t5/Building-Flows/Link-to-file-to-open-PDF-in-SharePoint-reader-vie...

[Christian34726554idyd]

I'm trying to accomplish the same thing, when opening files in notion, that are stored on sharepoint.

A solution would save us so much repetitive work...

[Christian34726554idyd]

A workaround I'm thinking of, is to link to the folder instead of the file. It then opens in the browser, where you can use the o365 adobe cloud app

[Denis34712654dkps]

Hi,
Thanks for the proposal that can be an option for a manual single operation. 

My objective is to include the hyperlinks in a register of documents so that when clicking on the name of the document it opens the document. In my case a folder can have high number of files. Pointing the folder has a limited interest in this specific case.

[Christian34726554idyd]

check my reply to OP, to see a solution.

[Christian34726554idyd · Accepted solution]

I asked this question in a Microsoft Forum and got the following workflow.

Append "?web=1" to the weblink.

So if the link is

https://...-my.sharepoint.com/personal/.../Documents/../Test/Testdokument.pdf

append ?web=1

https://...-my.sharepoint.com/personal/.../Documents/../Test/Testdokument.pdf?web=1

This will open the web view.

In the web view you can select Open in Adobe Acrobat.

[ls_rbls]

Amazing!

Thank you for sharing.

[Christian34726554idyd · Accepted solution]

I forgot to mention this in my earlier reply.

I got the solution from this User:

https://answers.microsoft.com/en-us/profile/48b32a98-01a9-4724-b65c-037efb52fdb3

[Ray24994638n6q7]

This is a great presentation.  The operation does not work for me.  When I append the ?web=1, the result is the default webviewer (as without the ?web=1), and there are some additional features.  None of those features provide a direct means to view the pdf in Adobe.  Any suggesgtions?