Hello,
I have an excel workbook saved to my Sharepoint site. The workbook uses Power Query to pull data from excel workbooks that are saved to my Onedrive for Business (there are reasons they are saved in Onedrive for business, which I can go into if curious).
I have synced the Sharepoint, Onedrive for Business, and a Personal Onedrive account to my computer.
When I open the Sharepoint excel file from Windows Explorer, I get the warning "Upload Blocked...We ran into a problem with this file and can't save any changes". If I quit Onedrive for Business, I don't have this problem, but I don't quite understand why.
It is not ideal to continuously sign out of onedrive for business as I am regularly working with those files as well. Thanks in advance for your help.
Anne