Excel hanging on "Saving" dialog box
Results 1 to 4 of 4

Thread: Excel hanging on "Saving" dialog box
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2018
    Posts
    305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel hanging on "Saving" dialog box

    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!
    Last edited by RockandGrohl; Jul 30th, 2019 at 04:07 AM.

  2. #2
    Board Regular
    Join Date
    Aug 2018
    Posts
    305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel hanging on "Saving" dialog box

    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.

  3. #3
    Board Regular
    Join Date
    Aug 2018
    Posts
    305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel hanging on "Saving" dialog box

    Bump

  4. #4
    Board Regular
    Join Date
    Aug 2018
    Posts
    305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel hanging on "Saving" dialog box

    Double bump!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •