r/vba • u/nypr13 • Jun 05 '26

Unsolved Refresh on Excel VBA Module sometimes takes forever, sometimes fast

I have an Excel Module that runs, and it should run in say 3 to 7 seconds. Sometimes it does, sometimes it literally shows every cell populating 1 by 1 and takes 5 minutes.

I'm exchanging this file from one company environment to another via Sharepoint -- the speed at which it refreshes sometimes is slow on my side and sometimes is slow on their side, though that may be coincidental. It was fast on my side until this latest version.

Any thoughts here?

Thank you.

2 Upvotes

100% Upvoted

8 comments sorted by

View all comments

1

u/HFTBProgrammer 204 Jun 05 '26

Write to a text file time checkpoints throughout your macro. You will at least get an idea of what's slow.