OneDrive


Feedback by UserVoice

Caleb

My feedback

  1. 1,229 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    96 comments  ·  OneDrive on Windows  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Caleb commented  · 

    hey guys, I've managed to make the reference link to stick to the local filepath instead or reverting to the remote URL link everytime the file is reopen.

    Solution:
    - Step1: Break all the links in the excel file (make sure u keep the formulas cause u'll need it again to rebuilt the connection)

    -Step2: Cut the excel file and paste it in either another folder or a subfolder (goal: make sure both excel file isn't in the same folder)

    -Step3: Rebuild your formulas

    I know this sounds weird, but simply moving the excel file to another folder kinda works for me, making the reference link stick to the local filepath instead the URL webpath.

Feedback and Knowledge Base