PDF writer returns multiple PDF documents not just one!

Q) When i go to produce a PDF from an Excel spreadsheet, it will break my multi worksheet document into several PDF requests.

A) The issue was caused by having different page properties on different worksheets. When sent through the Adobe PDF printer (or Cute PDF) as soon as it got to a worksheet with different properties is will see it as a different request and prompts for a PDF file name.

To resolve this issue see below.

1 Right click a worksheet and "select all sheets"
2 Select 'Page Layout' tab and 'Print Titles'
3 On the 'Page' tab select the print quality to 600 DPI and click OK

This will make a change on all worksheets, and if you go to file print or through Acrobat > combine it will convert all