3

I am trying to print a workbook to pdf, but for some reason, it is attempting to save to multiple files. About 10 pages want to save in 2-3 pages per file, then the rest (another 15) save to the remaining file, totalling ~6 separate files. This happens with both Adobe and CutePDF Writer.

How can I print the entire workbook into one file?

  • I don't see the reason for the -1 or the close vote. It is indeed strange behavior of Excel. – agtoever Feb 26 '15 at 22:44
5

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.

Excel - Print entire workbook

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 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.

3

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

0

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.

enter image description here

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.

0

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".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.