Forum Discussion
Excel operates very slowly and stops responding constantly, how to fix?
I had an experience. If the excel file is located in Google Drive File Stream, the performance will be down-graded. As the file I am using contains a lot of macros, sometimes it will prompt a dialog box saying that "Excel is waiting for OLE connection" (something like that, I forgot the exact wording).
Another suggestion is the calculation. In case the file contains a lot of formulas (OFFSET/COUNTIF) and the calculation mode is automatic, it will also slow down the operation.
Thank you for the information. Unfortunately however, my problem is not solely related to a single excel file, but the entire program itself. The problem begins before the loading of any file and persists to happen after any file is loaded.
If I do not find a better solution, I think the only solution I have left is to recover my storage drives to before the installation of all my softwares and reinstall everything.
