PROBLEM:
You are trying to create a PDF file of an excel file with multiple worksheets by printing through a PDF writer like for example DoPDF. The result is that you get multiple PDF files. You can't create one PDF.
SOLUTION:
This is caused by worksheets that have different DPI settings. Change all worksheets to the same DPI setting and it will work.
