PW - Create rendition from Excel spreadsheet (consisting more than one sheet)


I'm trying to PDF a spreadsheet than consists five sheets. Unfortunately, my observation is that Create rendition command prints only active sheet while the rest of sheets is missed. Is this possible to PDF a spreadsheet consisting more than one sheet? 

I came up with the idea that changing default excel printing setting from Print Active Sheets to Print Entire Workbook might help, but it looks like (I didn't manage to find out how to do this) it's impossible to change this setting!

Anyone came across this problem? hanks.

Kind regards,