Forum Discussion
no links/VBA/addons, but : Microsoft excel waiting for another application to complete an ole action
Helen_M Has anyone found out why google file stream is causing this issue? Having my users save a copy of every excel file on their local station isn't feasible.
I'm not sure if my explanation will help but this is the way I believe things should happen when using OndDrive.
Firstly, if you're using a corporate OneDrive area, person A should create the file locally and then sync it to a private or business OneDrive/MS Teams shared area. Then, person B can open a copy from that shared place and save it to their own local area so it can be worked on. From then on both person, A, & person B can each open their local copy of the file and it will automatically be synced to the business OneDrive/MS Teams area (SharePoint) as and when they make changes [unless they turn off the sync option, in the top left-hand corner of their screens].
If someone e.g. Person B, tries to open the shared file on OneDrive WITHOUT saving it locally, this will cause problems (even if they're using only their personal OneDrive, based on my own experience!) as it will affect the connection back to person A. I think this is because synchronisation is only one way?
The second point, which may be more relevant to you, is that the OneDrive and Shared areas are not seen as being local to your machine (maybe in the Microsoft cloud or a business server held off-site) in which case, anything you do to a file in the cloud will be checked by your virus checking software. In other words, virus checkers rarely trust Excel or MS Word files because historically they could have contained malicious VBA code. So every time you make a change, the virus checker will look at the file to see if it's bad. Inserting a column means it needs to check every new cell - even if it turns out to be empty. Very time-consuming but it's trying to protect you and based on the same algorithms that check emails. How big your file is, how many calculations you have in it and what you've changed will impact these checks greatly. So the bottom line is, use your local copy, it should automatically sync up to OneDrive (can still be shared) and everything should then be ticket boo!