Forum Discussion
Excel sheet hyperlinks linked to a server that's changing locations
Hi, I am creating an Excel sheet which is going to have numerous links to drawings. If the drawings were going to be hosted on one particular server I would just statically map the link for each...
You may use =CELL("filename") which returns the text with full path of Excel file location, parse it to extract root directory or server name, add subdirectories and combine in HYPERLINK.