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
    2010-12-30T23:18:16+00:00

    Raju,

    I don't use macros.

    I created a new spreadsheet with 2 tabs, one for a simple list of data, and another where I created a histogram graph of the data.  I saved the file to my hard drive, then went into print preview (from the quick access bar) and adjusted the margins then went back to home button then tried to save again and got the same error message as below:

    "Errors were detected while saving C:\ filepath name.  Microsoft Excel may be able to save the file by removing or repairing some features.  To make the repairs in a new file, click Continue.  To cancel saving the file, click Cancel".

    Excel 2010 wont let me save my work after going into print preview or using the page setup button to add headers/footers to pages.  It also crashes like this if I try to use the print page preview button on the bottom bar and wont let me add the same footer message across multiple tabs as I should be able to do.

    This is the same problem that is happening in all my excel files after I upgraded to Excel 2010.  Never happened before.

    I think there is a serious problem with Excel 2010 which has not been addressed.

    Please give me the fix.  I am tired of the sheer hassle and frustration of trying to use the product.

    Thank you.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2010-12-30T20:54:47+00:00

    I think there is a flaw in MS Excel 2010.  Everything else on my system works fine too.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2010-12-30T20:53:39+00:00

    Raju,

    File is saved locally to C drive.

    The problem also happens with newly created small excel files (1 data tab and 3 graphp tabs.  Its bloody annoying when you are trying to be productive for a clienta and the file keeps crashing when you try to save after using page setup or page preview.

    I am concerned that you are getting me to try things but don't actually know what the problem is or how to solve it?  I am happy to try the clean boot although it is a lot of work in case an internal software conflict is the problem, but the enduring question is why is it doing this ONLY in Excel, and ONLY in 2010?

    I think there is a fault with Office Excel 2010 which Microsoft has not acknowledged.  I have NEVER experienced this problem before on ANY computer or any other MS program or any prior version.

    I look forward to your insights.  Do you know what the problem is?  Have you heard of this problem with other users?  Do you know what teh solution is?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2010-12-30T16:16:13+00:00

    i have this same problem with all files, network and local and most of my files are below 500kb. 

    there are no macros in my files.

    all my other office programs work fine.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2010-12-29T10:49:36+00:00

    Where is this file saved (locally or on a network location)?

    Does it contain any Macro?

    Does this issue happen with one specific file or with all excel files?

    Create a new test Excel file, and check if it works fine.

    Was this answer helpful?

    0 comments No comments