Excel "Print to PDF" creating multiple files

I had a similar problem, which I discovered was due to different DPI settings on each page.

I followed these instructions and it worked perfectly:

In order to set the DPI value for each individual page, you have to follow these steps:

1. Open the Excel workbook
2. Select the sheet you want to set the DPI for
3. In Microsoft Excel 2007/2010/2013 go to Page Layout and click on the expand button for the Page Setup dialog (for Microsoft Excel 2003 or earlier go to File->Page Setup)
4. In the Print Quality section enter the DPI value that you want to have for your document (note that this is the DPI value you will have to set for each individual sheet too) and press OK

Source Printing an entire Excel workbook to a single PDF file

I understand you are trying to print the entire workbook instead of just one worksheet (see screenshot). If that's the case, the default Excel behavior is to send each and every worksheet separately to the printer. That causes the PDF writer to create a separate file.

The solution is quite simple and I borrowed it from this site - thanks Helen Bradley! Follow these steps:

• Select all worksheets (right click in any worksheet tab and click "Select All Sheets"
• Select "File", "Print..." and "Print Active Sheets" to PDF.

For some magic reason Excel now appends all output to the printer instead of sending each and every worksheet separately. This creates one PDF file with all worksheets in it.

While this is not a direct answer to the question, it is a solution -

I managed to get the Adobe Acrobat plugin working so that I could use the "Create PDF" option in the "Acrobat" Ribbon toolbar.

To do so, I had to:

• Make sure that I had the correct version of Acrobat (Microsoft Office 2013 only works with Adobe Acrobat XI)
• Make sure Acrobat was up to date
• Add the Adobe PDFMaker Office COM Addin in Excel (Generally found in C:\Program Files (x86)\Adobe\Acrobat <version>\PDFMaker)
  • To do this, go to File > Options > Add-ins
  • At the bottom of the page, in the "Manage" dropdown box, select "COM Add-ins"
  • If you have this already in the list, disable it, then re-enable it. If not, click "Add" then navigate to the file (using the path mentioned above)
  • Restart Excel.

That should give you this ribbon option, which will create a single pdf of the entire project.

The only thing that worked for me was to SAVE AS then select type as PDF and then on the Options button select "Entire Workbook".