Excel pause on document close

[davidmulcair]

Hi there,

One of my clients is having a problem where when he closes a document saved on the network it freezes. He's not even saving the document, it just stops for about 30 seconds, then will close.

At first I thought it was a network issue, but ruled that out, as there is no delay in doing transfers to/from the fileserver. Also, these documents are not being accessed by other users.

Any ideas? TIA.

David

 

[SteveBausch]

Hmmm....out of my league on this issue.

I would put a breakpoint in the BeforeClose event, then step through the code.

Try to figure out if the problem follows the file, stays with a specific computer, etc. Try to isolate, try to repeat.

 

[davidmulcair]

I should correct myself. No code in the document itself. "Excel pause on document close" should read "Excel is pausing when I close a document"

 

[SteveBausch]

If you have any workbooks loaded with BeforeClose or Deactivate events, those will be invoked when closing Excel. And maybe some other events I missed.


So.....

Is this a new user? Not a new office, not a new desk, not a new computer.....I mean a new employee.

Are they loading the correct workbook? Not a copy?

Is this (new) employee loading multiple workbooks? And nobody else does this? Do they close the workbooks one by one, or do they hit that big red X and close their eyes? One of those books has code (my wild and crazy guess)

Does this computer have any sort of a Personal.Xls workbook?

I swear to God, you cannot anticipate the behavior of users, and it seems they can delight in deviant behavior. You either tell them "DON'T DO THAT!", or you go back and write better code.


I suggest this as a diagnostic. Determine the exact computer it is, the exact boot, and the exact version of Excel. Set the Macro protection at least high enough to prompt the user if macros are loaded. Insist that they Disable Macros everytime they see that dialog. Listen for complaints. If they complain, they are running macros that no longer are available. Go look at the book that contains the macros.