Multiple Excel sheets Printing back to back

Question

Since I work in large no. of Excel sheets (One file contains 15 to 35 work sheets), when I fire a print command for Entire workbook with back to back printing, there are few pages that doesn't get printed back to back even though page size and other things are same.

One common bug I found is that, If a work sheet is copied from other excel file, this problem is common.

Answer 1

Does this issue occur only with specific Excel file or all Excel files?

Are the Excel files saved on local hard drive or on network?

You may change the default printer to a different printer and check if it helps.

Refer the link below to know how to change the default printer:

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/print\_set\_default\_printer.mspx?mfr=true

Answer 2

The Page breaks are fine and page size and even matter are exact. Still problem is not solved.

Answer 3

I had checked print area, margins and also unused cells that may create a problem. But every thing is in order except back to back print for two work sheet.

Answer 4

You may also verify if the page breaks are setup correctly because to print a worksheet the exact number of pages that you want, you can adjust the page breaks in the worksheet before you print it.

For more information refer the link below:

http://office.microsoft.com/en-ca/excel-help/insert-move-or-delete-page-breaks-in-a-worksheet-HP010021539.aspx

Answer 5

Double check the Print Area for each worksheet. best wishes

---

Bernard Liengme, Nova Scotia, Canada http://people.stfx.ca/bliengme/