Hi James,

I should have mentioned I've tried this option.

It seems to be quite inconsistent, sometimes all sheets will print,
sometimes a couple,

Any further suggestions?

:)

"James O" wrote:

Instead of hitting print and selecting entire worksheet, try selecting the
first tab, hold shift and selct the last tab. now all tabs should be
selected, the hit the printer button, this should print all pages in the
workbook

"Charlotte Howard" wrote:

Hi,
I'm currently using Excel 2003, and have recently come across an issue when
printing an entire Workbook. Only a few worksheets will print. For example,
a Workbook with 25 sheets will only print 7 at a time. Another with 10
worksheet only prints 1 at a time.
They used to print out fine. Has something wierd happened?

It's particularly annoying when creating PDFs!

Thanks for any light shed

Charlotte