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-03-12T10:27:12+00:00

    I have the same problem,  even with one sheet spreadsheets,

    Tried all the above , WIN7 6bit clean install, office clean install, still happens.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-03-09T17:55:32+00:00

    Another user with the same problem.

    Windows 7 Ultimate (64-bit)

    Office 2010 Professional (64-bit)

    HP Photosmart D5360

    (best printer I ever had-would give up Excel before changing printers)

    This seems to be typical Microsoft response.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-03-06T21:20:28+00:00

    Have discovered this thread and read through all the comments with a wry twisted grin on my face, nodding to myself in appreciation of the complete frustration shared with everyone else - I too have been experiencing all of these issues.

    • Windows 7
    • Office 2010 Professional
    • HP Photosmart C8180 printer

    My quickfix has included (with limited success) to save the file as an Excel 97-2003 workbook and continue - sometimes it works, sometimes not.  I have learnt to complete all content on the file prior to setting the print settings.

    Bill - as and when an update is available, I (and many others) will no doubt be in your debt.

    Thanks,

    Sean

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-02-15T17:49:33+00:00

    Thank you.  The user that is having the problem in my area changed her default printer from the HP Photosmart C4200 printer to RichoMP4000 Copier - I don't have driver version.   So far she has not had the crash problem moving between print preview and then back out to the document.     I will get the print drive details.  Susan

    Was this answer helpful?

    0 comments
  5. Anonymous
    2011-02-15T01:22:17+00:00

    I have heard back from the Excel product manager.

    He confirms that it is a known issue with Excel 2010 and a small number of printer drivers.

    They don't currently have a workaround, unfortunately, but it is a strong candidate for attention in the next service pack (SP2) and in the next version of Office.

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

    Was this answer helpful?

    0 comments