Crashes on File-Close-Save

[Dave Miller]

I have a reasonably complex workbook (multiple sheets /
macros) that crashes periodically upon closing and
saving. Error message displayed is "EXCEL.EXE has
generated errors and will be closed by Windows. You will
need to restart the program. An error log is being
created."

The Dr Watson log contains the following info:

Application exception occurred:
App: (pid=788)
When: 12/30/2003 @ 10:09:35.189
Exception number: c0000005 (access violation)

Problem is that the error is difficult to replicate
consistently. I have not been able to determine a pattern
of actions that cause this error and the error does not
occur every time.

Also, when the workbook is reopened, all have been
properly saved and things seem to function OK.

Running Excel 2000 under Windows 2000. Other users have
experienced problem with Excel 97. I have not seen the
problem when running the workbook in Excel 2000 on my
Windows XP machine.

Help much appreciated.

Dave Miller

 

[Nick Hodge]

Dave

Ridiculous length URL, but this is a search in the MS knowledge base for
crash on close, Access Violation in XL for windows. There are several
solutions given, but I don't know if any fit yoyr problem. (Copy and paste
the URL together in Notepad and paste into IE)

http://support.microsoft.com/search...chstep=1&InCC_hdn=true&querySource=gASr_Query



--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)