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 No comments

94 answers

Sort by: Newest
  1. Anonymous
    2012-07-21T14:17:43+00:00

    Excel 2007 DOES have the same problem.  Has been working fine but for some unknown reason this week has simply decided to crash every time I click print preview.  It doesn't matter which printer I try (tried all of the above), installed, reinstalled tried every version of excel to save files as...

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2012-07-02T15:22:14+00:00

    Same issue here, using HP C4280, tried installing new HP drivers 3 times, tried everything...crashes ALL THE TIME. I am doing consulting work and billing out my time for well over $100 per hour, and every #@$#%#%@$ time this happens it costs me, big time.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2012-03-23T10:09:45+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?

    This is a Catastrophic BUG.. If you leave yous printer switched ON, the problem goes away.

    What is happeneing is Excel is communicating with the printer most likely to find out what the margin settings are; rather than taking them from what the user has set in the excel file.

    Millions of People and Corporates leave their printers on 24/7/365 because of this BUG!

    This Pumps Millions of Tons of CO2 into the atmosphere!

    Microsoft..  You can fix this in a week..  Please Do so!!

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2012-01-23T18:00:21+00:00

    But I'm having the problem with:

    Windows Vista

    Office Home & Bus. 2010

    HP J5780 All In One Printer.

    Was this answer helpful?

    0 comments No comments
  5. 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 No comments