links refuse to change from sharpoint address..

[JamesBowdidge]

Hi, So my (work) laptop backs up files to the cloud via sharpoint, but all files a stored locally on my PC.. I have some linked spreadsheets (both on the laptop) but when linking them together rather than the usual file location its a sharpoint address like this.. (this happens maybe 50% of the time, the other 50% its just a normal link!)

='

https://steria-my.sharepoint.com/personal

/james_bowdidge_soprasteria_com/Documents/James Bowdidge/Max slot backup/Manifest Max Slots/[Max Slots (LIB) 04.01.2021.xlsm]Max Slots Core'

However its not all the time, sometime the formula will not chage to an address as above and the link stays as it should just pointed at the file location on my PC..

When the HTTPs is in the formula they dont refresh, Sometimes a find and replace (with nothing) on this bit "https://steria-my.sharepoint.com/personal/james_bowdidge_soprasteria_com/Documents/James Bowdidge/Max slot backup/Manifest Max Slots/" and replacing with a blank (whilst the linked file is open) works and the HTTPs bit goes.. but sometimes I do the find and replace and it just immediatly comes back.. I can find no pattern in when or why the sharpoint address appears in the formula...

Any ideas on how to prevent this from happeneing and excel just carry on as if I do not backup to sharepoint? is there a setting somehere to prevent it?

please help!!

thanks

J