Forum Discussion
Dynamic Hyperlink: open a document (with the same value as in the cell) in a folder via a cell value
Hello, I want to be able to open a document via a dynamic hyperlink. In an Excel file I have 1 fixed cell that always contains a different article number after it has been selected from a lis...
Yes, judging by the discussion here this is hard to achieve: https://stackoverflow.com/questions/6293893/how-do-i-force-files-to-open-in-the-browser-instead-of-downloading-pdf
I have found the issue and the solution.
To open the download file automatically, you must adjust the setting in the browser.
Go to the downloaded file in the browser and right-click on the file and select the option 'Always open files of this type'. Repeat these steps for all types of documents you want to download/open. Most common types are Word, Excel, CSV and PDF files.
Thanks for your input!