Forum Discussion
no links/VBA/addons, but : Microsoft excel waiting for another application to complete an ole action
Hi, Excel stops working about every 20 minutes for a few minutes -I just have to wait - and then this message pops up: ""microsoft excel waiting for another application to complete an ole action"...
Hi,
I think is it absolutely be affected by Google Drive.
The solution is you save Excel files which you are opening to edit in the same location. (all in Google Drive or all in Local Hard Drive).
I think is it absolutely be affected by Google Drive.
The solution is you save Excel files which you are opening to edit in the same location. (all in Google Drive or all in Local Hard Drive).
DuyTran Good thought. I'm not using Google Drive. All my files are local or on my OneDrive.
In my case the issue was caused by the size of the data set and the lag in syncing the data to the could.
My suggestion.
- Copy the file out of your cloud drive, (Google or OneDrive)
- work with it locally and
- then copy it back to your preferred cloud drive when you're done or periodically as a backup.
