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...
If I understand your goal correctly, you could explore setting a hyperlink base for the workbook.
Work with links in Excel - Microsoft Support
See: Set the base address for the links in a workbook
With a base set, you'd only need to refer to the file name in the fixed location.
- Patrick2788
Thanks for your option!
But in my workbook I have multiple links to other folders.
So, if I understand this option correct (wet the base address for ALL the links in my workbook) then this does not work for me.
But thanks for your thoughts!
