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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2011-02-08T18:17:30+00:00

    Ah, so a problem did occur with a non-HP printer?

    That is helpful information (I think!).

    I have alerted an Excel product manager to this issue by email as other approaches had not so far yielded any results.

    I will advise when I get a response.

    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-02-08T14:05:00+00:00

    Hi Bill,

       Yes it is a RICOH Aficio

    model: Infotec MP C5000 PCL 6

    and the driver is version 1.2.0.0

    It's a company network printer 

    Regards

     Steve

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-02-08T07:27:00+00:00

    Hi Steve

    For the colleague who "solved" the problem by changing printer, do you know what printer was being used when he had the problem?

    Thanks

    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-02-07T23:13:52+00:00

    User in my area is having the same problem - a google search produced this forum on the problem. 

     User has XP OS with Svc pack 3 - Had office 2003 - upgraded to Office 2010.

    Has an HP Photosmart C4200 printer.   When she goes into print preview, and changes margins in print preview - then goes back to file, excel will shut down.   Also happens when she simply goes to print preview and then back to the document.  Will shut down.  It is random, when it occurs.  For example, when she tried to recreate the problem while I was assisting her, it did not close down.   I will check the print driver and other suggestions already posted - but essentially see that no real fix has been determined yet. 

    Thanks for any additional suggestions.  Susan

    Was this answer helpful?

    0 comments
  5. Anonymous
    2011-02-06T21:19:14+00:00

    I must say I have to agree, I came across the possibility that the xlb file could cause the problem, but it took quite a while to find that as an option, and I found no definite indication that this was the cause. I only offered the suggestion for people to try it out and hopefully more people will comment as too wether it has any benefits or not.

    I should also add I didn't try it myself it was a college at work who had the problem of excel crashing when he tried to print preview, but he didn't feel comfortable 'messing about' and instead started using another printer.

    It does seem curious, I hope someone gets to the bottom of the problem.

    Regards

    Steve

    Was this answer helpful?

    0 comments