Excel hanging on "Saving" dialog box

[RockandGrohl]

Hi all,

Excel sometimes hangs on this dialog box

This happens at the end of a loop and in this instance, it successfully completed 55 iterations of the loop before it got stuck here.

Any ideas how to prevent this without disabling the save? I'm ok with it skipping one, two or even three saves as part of the loop but I would like this to save and also not hang overnight. Just to confirm, if I press cancel, the next time it saves as part of the loop it's fine and I can progress as normal.

Thanks!

 

[RockandGrohl]

Someone with the same issue as me said:

I solved this problem by adding calls to DoEvents before and after the .SAVEAS or .SAVE calls. It's just two days, but this seems to have taken a process that I run daily multiple times a day (that creates multiple workbooks to a shared drive and never got through a day without this bug happening) to being a perfectly hands off process.

However I'm not exactly sure where to start with this. I understand Do Events allows you to control CPU processes away from Excel.

 

[RockandGrohl]

Bump

 

[RockandGrohl]

Double bump!