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?