Links in an Excel file stored on OneDrive do not refer to local file

Question

I have an Excel file that is created locally and backed up on OneDrive. I need to be able to give this Excel file to someone else who will not have access to my OneDrive file, and who may not even have a OneDrive account. Any links from one worksheet to another within the file show the path to the OneDrive file instead of the local file. How can I change the links to not refer to the OneDrive file? Instead of the link showing "https://d.docs.live.net/...[filename]'worksheet!cell'", I want it to just have "worksheet!cell". Editing the hyperlink does not work. I closed Excel and opened the local file explictly, and it still shows the OneDrive link.

Answer 1

Hi,

Because files synced to OneDrive are online files that are synced in real-time.

It is recommended that you click on the OneDrive icon and go to Help & Settings>Settings>Office to uncheck the "Use Office application to sync Office files that I open" option to check this issue:

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.