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

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

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

Any chance that it's the printer/printer driver that's the problem?

I'd try a different printer to see if that helped.

Just curious: What happens when you group the sheets, but do a print preview?
Do you see everything or do you have the same problem?

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

--

Dave Peterson

Hi Dave,

When I use print preview, I see all the sheets in the workbook.

I've only printed to a Canon and Adobe Acrobat printer. I've printed
multisheet workbooks from another PC to the Canon with no problems!

Thanks
C

"Dave Peterson" wrote:

Any chance that it's the printer/printer driver that's the problem?

I'd try a different printer to see if that helped.

Just curious: What happens when you group the sheets, but do a print preview?
Do you see everything or do you have the same problem?

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

--

Dave Peterson

Maybe it's time to yell at Canon and Adobe???

(I don't use either.)


Charlotte Howard wrote:

Hi Dave,

When I use print preview, I see all the sheets in the workbook.

I've only printed to a Canon and Adobe Acrobat printer. I've printed
multisheet workbooks from another PC to the Canon with no problems!

Thanks
C

"Dave Peterson" wrote:

Any chance that it's the printer/printer driver that's the problem?

I'd try a different printer to see if that helped.

Just curious: What happens when you group the sheets, but do a print preview?
Do you see everything or do you have the same problem?

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

--

Dave Peterson


--

Dave Peterson

You know, you could be right!

Thanks
charlotte

"Dave Peterson" wrote:

Maybe it's time to yell at Canon and Adobe???

(I don't use either.)


Charlotte Howard wrote:

Hi Dave,

When I use print preview, I see all the sheets in the workbook.

I've only printed to a Canon and Adobe Acrobat printer. I've printed
multisheet workbooks from another PC to the Canon with no problems!

Thanks
C

"Dave Peterson" wrote:

Any chance that it's the printer/printer driver that's the problem?

I'd try a different printer to see if that helped.

Just curious: What happens when you group the sheets, but do a print preview?
Do you see everything or do you have the same problem?

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

--

Dave Peterson


--

Dave Peterson