Printing multiple worksheets duplex on seperate pages

[Milos]

I have about 50 worksheets in a workbook that I want to print at the same time. Being not the wasteful type of person I naturally want to print them all in Duplex but with each worksheet on a new separate page. Each worksheet has a different amount of content so can be anywhere from 1~5 pages long.

The problem is that when i print the first couple worksheets the duplex takes over and starts linking all the worksheets together

For example the first two worksheets had 3 (1.5 duplex) and 1 (0.5 duplex) printable pages respectively. The second worksheet is automatically printed on the back of the first worksheet = 2.0 pages duplex.

I want the first worksheet of 3 printable pages to print with 1 double sided page and 1 page with a blank page on the other side and then so~on.

Is this just my weird printer settings? How should I resolve this?

 

[apr pillai]

Insert a Page-Break (Page Layout-->Breaks) at the end of each worksheet's logical end of report area and try out.

 

[Milos]

Yeah I had trialled inserting page breaks but the only issue is that my 50 sheets will soon go up to 200 sheets. And being the lazy boy that I am.. I'm really after a more automated solution..