Excel 2010 crashes when using print preview button and adding headers/footers

Anonymous

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?

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

Anonymous

2010-12-19T12:45:04+00:00

Change the default printer to Microsoft XPS Document writer or to OneNote 2010 and then try to print preview using the Excel document and verify the status.

Refer the link below to change the default printer.

http://windows.microsoft.com/en-US/windows7/Change-your-default-printer

If it works fine, then click on the link below to update the printer drivers:

http://windows.microsoft.com/en-US/windows-vista/Find-and-install-printer-drivers

If the above steps fail, you can repair excel 2010 by referring the link below and check if it works fine.http://office.microsoft.com/en-us/excel-help/repair-or-remove-office-2010-HA010357402.aspx
Was this answer helpful?

0 comments No comments
Anonymous

2010-12-24T07:14:29+00:00

Raju,

Thank you. I will try this but please note that I have checked with HP and my printer driver is the latest and I did try to repair Excel 2010 with the install disk and it has not made any difference.

Why does this problem just persist with Excel and no other program? It leads me to believe that there is a flaw in Excel 2010.
Was this answer helpful?

0 comments No comments
Anonymous

2010-12-24T17:57:27+00:00

Raj,

None of your suggested remedys above have worked. Changing the default printer asks me to save the file in xps format doesnt make any difference. Printer drivers are the most current from HP for Win 7. Office 2010 repair which I had already done once before also makes no difference.

After repair I rebooted computer and then I went back to the Excel file and clicked on print preview and back to home 3 times, then clicked save as document and Excel crashed, and recovered my file. Something is wrong with Excel on my computer. All other Office 2010 programs don't have this problem on my computer.

The particular excel file is 2.35mb in size and has 77 tabs. The problems experienced are:

I cant click the print preview button on the quick access toolbar without it crashing Excel and restarting. After 3 of these instances excel shuts down

I cant use the add header/footer button within the page setup button on the quick access toolbar to add a footer to a tab more than 4 times without it crashing as above and restarting & recovering

I cant add the same footer simultaneously across all tabs at the same time (highlight all spreadsheet tabs, click on page setup, add header/footer, enter footer language, exit). When I do this it crashes excel as above.

Do you have any other suggestions?
Was this answer helpful?

0 comments No comments
Anonymous

2010-12-28T11:38:47+00:00

Start the computer in clean boot and check if it works fine.

Refer the article below to start the computer in clean boot:

http://support.microsoft.com/kb/929135

Note: Ensure to restart the computer in normal mode by following Step 7, after completing the troubleshooting steps.
Was this answer helpful?

0 comments No comments
Anonymous

2010-12-28T23:03:34+00:00

Raju,

Is this the only solution you can suggest?

Richard.
Was this answer helpful?

0 comments No comments