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-05-26T06:37:50+00:00

    Hi Laurie

    Another user (on another thread) has pointed out that the "enable multi-threaded processing" setting does not "stick" between runs of Excel. 

    Can I ask - when it crashed in preview had you re-started Excel since clearing the setting?

    If you are not certain, please could I ask you to try once more, clearing the setting and then repeating the preview test?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-05-25T23:14:31+00:00

    Oh dear.

    Thanks for trying it.

    I have passed your feedback on to the product team.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-05-25T17:36:51+00:00

    Just changed that setting, and tried printing a spreadsheet that always crashes for me.  I printed it once with no issue.  However, as soon as I went to the print preview and scrolled through the report to see what other pages looked like, then it crashed again.  I sent the error report via the normal dialog, but I also have a screenshot I can send if that would help.  This bug is the bane of my existence…

    I will be happy to try anything they can suggest and if a remote debug session would help I am amenable to that.

    Thanks,

    Laurie

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-05-25T16:12:06+00:00

    HOT OFF THE PRESS....

    The product team have identified a possible way to avoid this problem.

    They are currently testing it but have given me permission to suggest it here too, so that you can see if it solves the problem for you. 

    File > Options > Advanced > General : uncheck Enable multi-threaded processing .

    Please try it and let us know whether or not it avoids the problem for you.

    Thanks for your patience (as they say).

    Was this answer helpful?

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