I am working in an Excel file and trying to link a table of contents to other cells on the sheet – easy enough. The issue I am coming across is that all of the hyperlinks that I put into this document are giving a FULL file path and making it impossible for other users of this file to get access to. When I hover over the link it shows the following:
file:///C:\Users\Username....etc
My goal: I want these internal links to be local to the document we are working in so that when other users click on it, they won’t error out due to path issues
Ex: When I hover over the link, I want it to read:
File Name - Sheet1!A1
Not sure if this makes a difference, but my original file is located on a shared Box drive.