Excel 2010 Print Entire workbook problem

  Jento 10:35 10 Jan 2012
Locked

Hi All,

I have been searching for ages on this and tried multiple things, however I still haven't got any closer on this issue.

I am looking to print a 57 sheet excel workbook. However when I print the entire workbook, the sheets come off in all different orders to the original order on the workbook.

I am not the original owner of the workbook so I am not sure how it was created and no one can give me a sufficient answer to that question, but I am assuming it was collated from different sheets in different workbooks to create the one I am now on.

Is there anyway to stop this from occuring as it is a pain when you print this kind of thing off and need to re-arrange it all when you get it.

Any help would be appreciated.

Cheers

  TonyV 11:31 10 Jan 2012

Jento

I have no doubt you have tried various Google searches, but I came upon this one, may be it will help! PrintComplete Workbook

TonyV

  Woolwell 12:24 10 Jan 2012

This can happen if some of the pages overlap the edges eg it is set up for landscape and you print in portrait. Have a look at print preview and the print boundaries should also be shown on the worksheet.

  Jento 12:58 10 Jan 2012

Hi guys,

Thanks for replying.

TonyV I have seen all these kind of things and they're pretty generic but thank you. :)

Woolwell, I have all the sheets set in landscape and they also print in landscape.

I am not sure what you mean by print boundaries, is this the pritn area? If so I have removed all these and still the same happens.

Cheers

  Woolwell 13:20 10 Jan 2012

It was actually page breaks that I was thinking of Page breaks. If the page breaks are set an awkward place you can get what appears to be odd print orders.

  Jento 10:16 11 Jan 2012

Thank you for your help Woolwell!

Seems to of got me sorted!

Cheers

  Jento 10:59 11 Jan 2012

Tell a lie :(

It has sorted some of it out.

However I have noticed when i send the job to print there is like 4 job qued for 1 job in the print que.

I think this is causing the job to print from different areas in the workbook.

Any ideas how to get this to be 1 job in the print que?

Cheers

  Woolwell 11:47 11 Jan 2012

Are you selecting to print the entire workbook? Must admit that this one has me puzzled. Have you had a look at your print preferences and printer driver?

  Jento 15:02 11 Jan 2012

Its network printing that is used, all the printers are on a domain controller.

I'll have a look at my preferences.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)