Excel Crashs When Trying To Save File, Help.

[Guest]

Some times when I try to save a file in Excel 2003 I get an error message
that the program must close. It comes back up and I can save the file like
in a save mode. The program than resumes as normal. Every once in a while
it crashes and does not come back up and half the time it work just fine. I
have run the repair and it found no problems. Help

 

[Bill Manville]

If this is a particular workbook that has the problem it may be a bit
corrupted or close to some limit that is causing Excel to crash on
save. If it happens with various workbooks then it may be you have a
mis-behaving add-in installed.

General advice:
- ensure you have the latest updates from Microsoft Update
- if you have an application crash, do send the error report to
Microsoft (they may let you know of a solution)
- if you have an application crash, do click on the link to view
details and note the module and address in which the error occurred.
This information can be useful in identifying the cause, so report it
in a message here.
- if the problem is with a particular workbook, see if you can identify
what type of changes trigger the problem.
- if the problem affects different unrelated workbooks then try
uninstalling any add-ins and seeing if the problem is add-in related.

Bill Manville
MVP - Microsoft Excel, Oxford, England

 

[Guest]

I am having the same problem with two users. When saving, and sometimes
printing, their Excel 2003 crashes. I have reimaged their machines and they
are both on different types of PCs (both Dells, one a tower the other a
laptop). The images on their PCs are deployed across a large corporate
environment and are tested prior to deployment.

What might be the issue?

thanks,

Richard

 

[Guest]

We have the same issue, 3 of our uses report Excel 2003 randomly crashes when
saving or closing.

We have reimaged their machines (with our standard image deployed across our
environment), they have no add-ins and are working on lots of different
spreadsheets, some are older some are new.

I've had them copy the spreadsheets to their local drive and work on them,
Excel still crashes (they normaly work off network shares)

I've had them confirm they are saving the files in the Microsoft Office
Excel Workbook format

Two of them have Acrobat one of them doesn't, we all have Symantec Antivirus
Corporate edition, running with a managed parent server.

I'm going to try Office SP 3 next. If that doesn't work, I don't know what
to try. I can't upgrade them to 2007 because of incompatibilities with the
version of SAP we are running.

 

[Guest]

We finally resolved the issue.

Specifically this is what was happening. The user would open a new Excel
document, fill one (or more) field(s) > Print Preview > Print Setup > Close
(print Setup and Print Preview) > Print [OK] > Save [CRASH].

Or, the user would open a new Excel document, fill one (or more) field(s) >
Print Preview > Print [OK] > Save (Save As) [CRASH].

The issue turned out to be related to an HP LaserJet 3005 printer driver.
The HP LaserJet 3005 was installed locally on all affected machines via USB
(although I did change one to a standard printer cable with no change),
selected as the default printer, and using the pcl5 driver. I changed the
driver to pcl6 but no change. I changed default printer to another printer
and the issue went away. I changed the driver for the HP Laserjet 3005s to
an HPIII driver and the issue stayed away. I then changed the default
printer back to the HP LaserJet 3005 (with the HPIII driver) and the issue
remained resolved.

I hope that this helps someone--it was a bugger of an issue to track down.

Richard

 

[Guest]

I had another one this morning. It worked for him as well.

 

[Guest]

Can someone try the steps I outlined above and let me know the results? Even
one additional test would be appreciated.

Thanks

 

[Guest]

Hi Richard,

My users don't have local printers. We are using networked LaserJet 4250s
with a Windows print server.

I went ahead and tried your steps on my PC with one of our networked 4250s
set as the default printer.

Excel didn't crash on me.

In any case it's interesting to know about the HP printer drives. I'm
having my user test Excel with no printers added to her PC