Forum Discussion
Macro's in Excel from Microsoft 365 EXTREMELY SLOW
Step 1: I did a repair but that didn't make any difference...
Step 2: I removed and re-installed O365 (standard 64bit) but that didn't make any difference
Step 3: I removed and re-installed O365 32 bit but that didn't make any difference
Any more suggestions?
- Comment out the PDF generation. As I wrote, we observe disastrously slow data exchange with Word. I wonder whether your PDF generation suffers from similar problems. Does your ScreenUpdating=False now work after the re-installation? (That bit works here.)
After your reply I noticed something strange.
When I hit the 'create pdf' button on my userform it takes 38 seconds to finish creating the document and finish the macro'. But When I hit the 'create pdf' button and switch (alt-tab) to the folder in my explorer (and the macro runs in the background) it only takes 13 seconds to finish creating the pdf and finish the macro.... How is that possible?!
And this only happens in O365. In O2016 it works like a charm.
The screenupdating = false still doesn't work well in all routines. In some routines it works well but in others it doesn't. And this only happens in O365
- Thanks for your reply!
I will do a re-install. But I'm not the only one complaining about slowdowns.
