Excel 2010 crashes when using print preview button and adding headers/footers

Anonymous
2010-12-19T00:28:04+00:00

I am using Office 2010 Professional with Windows 7.  The installation was successful and I have no other issues with any Office programs except Excel 2010.  Whenever I use the print preview button on the Quick Access Toolbar to check the print preview before printing, or use headers/footers to add these before printing, Excel crashes and forces a restart when I next go to save the document.  It may allow me to do up to 3 print previews before I go to save the document and it crashes and attempts to recover the data or just shuts Excel down after a few times.

All other Office program functions work fine and I have checked my printer driver with a Microsoft utility and it reports no issues.

Can anyone help?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

94 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-01-23T17:52:42+00:00

    Me too!  Me too!

    I installed Office 2010 and having the same issues with JUST Excel and my HP Officejet J5780 All in One printer.

    Such a pain!

    Happens about every 3 times.  I MUST remember to SAVE, then I go to "View Page Break Preview" in order to get what I want to print.  And then it's hit or miss whether it will crash or not.  I called Microsoft and spent a long time with India who said to reinstall the printer software....no fix.  Then hired my fix-it guy who could NOT fix it...and told me it was a common problem and to wait for a fix...Then I had to write him a check.

    How will we know when there's a patch or fix?  Will it come through a Windows update?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-01-19T04:10:13+00:00

    sooooo....did you ever get a fix?  I have the same issue and I'm researching how to fix it.  I've spent hours on this and lost countless work because of this problem.

    Hoping for some answers.  Thnks

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-12-08T20:23:08+00:00

    Using Windows XP, Excel 2010, and HP 7280. Print preview then CRASH CRASH CRASH. Multiple times trying to print a document. WHY ISN'T THIS FIXED YET? Installed Office 2010 SP1, no fix. Updated to latest printer driver. Seems like lots of people are having the same issue. MS, anyone awake?

    I FIXED IT! Uninstalled Excel 2010 and installed Excel 2003. Fixed. Thanks MS

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-10-31T15:08:10+00:00

    Hi Bill,

    I seems to have similar problem as well but intermittent.

    Environment (in office):

    • Brother HL2140 laser printer connected through a network print server.
    • notebook connected to a wireless router which has LAN connection to the print server
    • all hardware (routers, servers & printers) are turned on before the notebook

    Environment (my house):

    • simple wireless connection without any servers and printers

    Hang happens randomly when Print Preview in a very simple 24 rows / 4 columns single sheet excel .xlsb file. I've rebooted Windows Vista many times. Failure rate seems to be in 40%~50% of the time.

    I can Print Preview at home without having the physical printer as well. But it doesn't change anything as failure rate is the same as when I'm in the office.

    Extra info: When it fails (hang) in print preview & I force-closed Excel2010, Control Panel->Printers hangs too.

    p/s: The excel file is on the Desktop, and I double click to open it.

    pp/s: I have tried with many different Excel files even with empty ones. Nothing improves.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2011-10-26T02:31:11+00:00

    I also went through both steps and have the latest driver.  Excel is still failing.

    Was this answer helpful?

    0 comments