File location problems when using OneDrive and Office 365

Hi everyone,

I am using Office 365 (Excel 2016) and OneDrive, and accessing my workbooks on several different machines - work PC, home PC, macbook.

Of course, I want to keep everything in sync, so in my OneDrive settings under Office > File Collaboration, I have ticked 'Use office 2016 to sync office files that I open'

When I open workbooks from within Excel, it often opens the 'docs.live.net' version of the file and not the local copy on my C drive. This causes problems with macros not working properly.

Does anyone have any tips for solving this problem? I don't want to directly reference a file location on my C drive in my macros as the workbooks are sometimes used on other PC's where the root folder names are different to mine.

I have a feeling that this must be a common problem, any advice is welcome

Andy

Thanks +AliGW, that works great.