Forum Discussion
TEXASFOREVER1936
Aug 09, 2022Copper Contributor
XLOOKUP TO RETUN HYPERLINK.
I have a spread sheet named "One Size Look Up (OSLU)" that can return numerous values of a certain criteria with XLOOKUP functions. I am trying to format a cell, in OSLU, to return a hyperlin...
Patrick2788
Aug 09, 2022Silver Contributor
If all the files are in the same location, you might want to try adding a Hyperlink Base to the workbook's properties.
File | Info | Properties | Advanced Properties.
My Hyperlink base for the test I ran: C:\Users\MyUserName\MyOneDriveName\Desktop\Test
Then in the sheet I can use HYPERLINK on the name of the file to open. Path not needed.