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: Most helpful
  1. Anonymous
    2011-05-25T07:20:44+00:00

    Thanks for the additional information.

    I can't help much on the Powerpoint issue. You might care to copy your paragraph on that over to a Powerpoint forum.  It does seem unlikely that the file was not being saved anywhere and that the original remained unchanged - my first reaction was that you had somehow got confused about the title or location of the file you were working on.  I assume you did a search for .pptx files including in hidden folders?

    I will keep reminding the product team that this is not a minor issue for those affected by it.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2011-05-25T00:33:09+00:00

    Hi Bill, thank you for the updates.  When I read your posts, they seem to suggest very minor problems with just headers, footers and previewing.  I just want to reiterate that in my situation, I bascially couldn't do anything in Excel.  Crashes were random and it could be while using "bold", soritng or anything.  Since Microsoft is going to eventually fix this, I just wanted to make sure that they understand that it is not a minor problem.

    Secondly, and it is probably not the topic for this forum as it pertains to PowerPoint.  However, I figured maybe I should mention it.  I must however say that I'm really not sure whether the problems are related.  I worked on a file for hours in PowerPoint and when I finally exited PowerPoint, I found that my work has not been saved at all.  It was an isolated incident and I have not had problems with PowerPoint since using the Office 2010 but since the Excel problems, I try to always exit Excel and restart after printing to make sure the default printer is back to the PDF Writer. The only thing different in this situation was that I printed using the HP driver and I had forgotten to switch the printer back to the PDF writer.  I just kept on working.  I must have saved no less than 100 times while working for the 5-6 hours.  There was no error message whatsoever.  I never even thought to check the file but when I was all done and finally exited, all the work was not saved and the time stamp was from the file 6 hours ago. I obviously checked that I did not save to a different name or under some other directory - there was simply no trace of work being saved at all.  I told one of my friends about the problem and she told me she had the same thing happen to her in PowerPoint except we don't have the same printer setup etc. and she does not have the Excel problems I have.

    In any case, I'm glad to hear that Microsoft will be working on the problem.  I must say that I am disappointed to hear how long it will take.  Although I've got a workaround, it is really a damper as I was so excited to get the new computer and software.  It seems unfair that we have to keep using "damaged goods" when we've paid so much money for "new and improved".

    CutePrinter

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2011-05-16T11:26:29+00:00

    Uninstall office manually and check if it helps.

    KB928218

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2011-05-10T23:57:38+00:00

    The suggested solution is to use a different printer driver (e.g. a PDF writer) while previewing and setting headers and footers.  I believe that actual printing to the HP driver without previewing is OK.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2011-05-10T22:23:41+00:00

    I'm having the same problem with my HP Photosmart C3180. I haven't found a solution yet other than using old versions of excel to print my documents.

    Was this answer helpful?

    0 comments No comments