Did you try these steps?
Open your workbook.
On the File menu, point to Print, and then click Properties.
On the Layout tab, select the one of the duplex options, and then click OK.
Click OK in the Print dialog box.
Repeat these steps for every sheet in the workbook.
When you print your workbook, all worksheets are printed with the duplex option.
Regards,
Wray