Google Sheet: Hyperlink to network file not opening
Thierry DUSSAUTOIR
-
okmerci Posted messages 19 Status Member -
okmerci Posted messages 19 Status Member -
Hello,
In a spreadsheet, I need to have a link to a file on the network. In Excel, it works, but it doesn't work in Google Sheets.
The formula is as follows:
=HYPERLINK("file:///\\DCTSVX006\SERV01\PAT-SAL-DIT_SECRETARIAT\DIR\COURRIER%20ARRIVE%20DEPART\Arrivée\Liens%202016\102.pdf";"M:\DIR\COURRIER ARRIVE DEPART\Arrivée\Liens 2016\102.pdf")
Is there a syntax problem?
Configuration: Windows / Chrome 53.0.2785.143
In a spreadsheet, I need to have a link to a file on the network. In Excel, it works, but it doesn't work in Google Sheets.
The formula is as follows:
=HYPERLINK("file:///\\DCTSVX006\SERV01\PAT-SAL-DIT_SECRETARIAT\DIR\COURRIER%20ARRIVE%20DEPART\Arrivée\Liens%202016\102.pdf";"M:\DIR\COURRIER ARRIVE DEPART\Arrivée\Liens 2016\102.pdf")
Is there a syntax problem?
Configuration: Windows / Chrome 53.0.2785.143
1 answer
-
The links lead to a local file. Google Sheets is an online spreadsheet tool, so it will not be able to find the file 102.pdf.
Solution: You need to host your file online and copy its full link.
There are several solutions for hosting, but if you have a Gmail account, you can simply upload the PDF to Drive, for example.
Example of an online link: http://www.google.drive.com/user/lorem/lefichier.pdf