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-08-09T14:41:52+00:00

    Thank you Alex for the disabled add ins fix

    Since building the users pc other "techies" had played with print drivers and printers.

    Your fix was good as her printers both network and local were in the disabled list.

    One thing I found afterwards is any spreadsheets that had been created that had crashed before, have to be opened (then they crash) and re opened again = as if excel has held some "I will crash and burn" shred file. Once cleared and reopened; then they print OK (obviously creating some shred file saying you wont crash and burn)

    OK this is the way I explained it to the user

    Thank you friend from one techie to another

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-07-20T04:37:47+00:00

    There is barely a temporary fix. Remembering to turn off multi-threading every time you try to print is not a fix. Most people have been patient but there has been no update on this issue for a long time. I have a friend with an old copy of Excel and I guess I will go back to that or try Open Office. It feels like the bad old days when you click save every 2 minutes just so you don't lose too much work...

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-07-19T13:51:48+00:00

    I am a new visitor to this post with the same problem.

    I dealt with the issue by saving constantly and once it crashed i would close out and reopen. Well, that, although tedious, got me by until finally it crashed my hard drive. My final Excel crash and close out left me with a humming sound (which ended requiring a new hard drive).

    I haves since changed my default printer to OneNote 2010 and disable the multi thread (as per these posts), so far it seems to work, bit ridiculous to have to deal with.

    Is there a more permanent fix?

    Thanks.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-05-27T10:49:33+00:00

    Thanks for the reply,

    I am already using the same technique

    Regards

    Sarang

    Was this answer helpful?

    0 comments
  5. Anonymous
    2011-05-26T16:08:42+00:00

    I just launched a new instance of Excel, and cleared the multi-threaded setting. Went into print and did nothing for a minute. But as soon as I tried to scroll through the Print Preview it crashed again. It does seem like if I remember to clear that setting and just don't touch the Print Preview at all, then I can at least print the document without crashing now. I will try to remember to do this while waiting for a real fix. I will just save less trees if I need to print a file in order to make sure that it is formatted the way I want it to be...

    Was this answer helpful?

    0 comments