Excel 2007 – Multiple sheets in workbook – 1 set of printer settings? Help!

I have a workbook in excel 2007, this has multiple sheets.

If i select all the sheets across the bottom and make a printer setting change like landscape, it will change it on all sheets. However when i go into printer properties and change it to print on duplex (2 sided) it only applies the changes on the active sheet. All the other sheets (apart from first one) will print on singles pages still.

please please help me? or just tell me its not possible!