An error occurred while saving the commentCaleb 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.
- 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.