Excel Relative Hyperlink

Question

I am trying to create a hyperlink from an Excel table saved in one folder to another folder in the same directory.  

Excel file saved in: P:"Project"\Eng  

Folder hyperlink to: P:"Project"\PM\Contract\ECA

"Project" represents different client folders, all saved in our network P:\ folder.  I can get a hyperlink to work properly for Client 1, but when I create a copy of the Excel file into the folder for Client 2, the link opens Client 1's ECA folder.  I would like to find a way to use relative path so the link doesn't have to be manually changed each time a new client is added.

Thanks in advance for your help.

Answer 1

Found the answer on another site: https://www.excelfunctions.net/excel-hyperlink-function.html

By using =hyperlink("..\PM\Contract\ECA"), I was able to path to the same client where the Excel file is saved.