Hi all

I'm having a problem with file locations with Excel using Microsoft OneDrive. First of all I am using Excel 365 with a default file location of the OneDrive folder on the C drive. All files are saved there
2 Problems - both related, I think:-

1. When I use hyperlinks to jump to another file in that same or other folder they initially work ok. However when I save the file and re-open later the hyperlinks have changed to a docs.live.net location and don't work.

2. I have tried recently to use the =cell("filename",a1) formula and it initially worked ok in that it returned the C: OneDrive folder in the path. Now for some reason it is returning the same docs.live.net folder that cropped up with the hyperlinks

I have the Excel Options ticked to Save to computer by default witha default file location set to C:\OneDrive so am at a loss how/why the docs.live.net folder keeps copying up.

When I save files in a folder not in my OneDrive it works ok so it seems related to the OneDrive

Any help would be much appreciated.

Kind regards

Roy Sibbett