Skip to main content
A
Anonymous
November 4, 2016
Answered

How do I merge only 1 worksheet from a variety of excel files to create a pdf?

  • November 4, 2016
  • 1 reply
  • 7828 views

I'm currently using the new Adobe Acrobat Pro DC and after I have selected all the files to combine, it is pulling in ALL the worksheets from the excel files. This is ridiculous.

In the older version of Adobe Acrobat Professional when combining files to create a pdf it only used the selected worksheets and didn't pull in the other unnecessary worksheets.

How can I get it to just combine the worksheets I want? I've checked the Edit>Preferences>General settings and the "Convert Entire Workbook" is unchecked. Not sure what else I can do.

Thanks

Julie-Anne

    This topic has been closed for replies.
    Correct answer ruchi_agrawal_adobe_2012

    Hi Julie,

    Combine PDF for only the desired sheets in multiple excel files can be done by:

    1. Launch Acrobat.
    2. Go to Edit>Preferences>Convert to PDF> Microsoft Excel>Edit Settings
    3. Uncheck the option “Convert entire Excel workbook”.
    4. Click OK and close the Preferences dialog.
    5. Close and relaunch Acrobat.
    6. Go to File>Create Multiple PDF Files>Add Files/Folders
    7. Add the file/folder containing workbooks you want to convert to pdf.
    8. Provide the Output Options and click OK.
    9. Check in the output folder that each pdf is created with only the active sheet of the workbook.
    10. Now you can Combine these pdf files in to a single pdf file by selecting all the pdfs and doing a Right Click>Combine files in Acrobat…

    Hope this helps.

    Thanks,

    Ruchi

    1 reply

    S
    Community Manager
    sb116Community Manager
    Community Manager
    November 4, 2016

    Hi Julie-annea53380061,

    Unfortunately, there is no way to make the changes you are referring to.

    Please let me know if you need any other help with it.


    Thanks,

    Supriya

    A
    Anonymous
    November 6, 2016

    Hi Supriya

    How unfortunate is that!

    This is a really huge step backwards in the Adobe Acrobat Pro DC package and has now created so much more work for users in deleting all the unnecessary worksheets related to excel files when combining to create a PDF.

    Are you likely to make changes to the package in the future and revert back to how Adobe Acrobat Professional worked when combining excel files that have a variety of worksheets that don't need to be part of the pdf?

    Thanks

    Julie-Anne

      R
      Adobe Employee
      ruchi_agrawal_adobe_2012Correct answer
      Adobe Employee
      November 7, 2016

      Hi Julie,

      Combine PDF for only the desired sheets in multiple excel files can be done by:

      1. Launch Acrobat.
      2. Go to Edit>Preferences>Convert to PDF> Microsoft Excel>Edit Settings
      3. Uncheck the option “Convert entire Excel workbook”.
      4. Click OK and close the Preferences dialog.
      5. Close and relaunch Acrobat.
      6. Go to File>Create Multiple PDF Files>Add Files/Folders
      7. Add the file/folder containing workbooks you want to convert to pdf.
      8. Provide the Output Options and click OK.
      9. Check in the output folder that each pdf is created with only the active sheet of the workbook.
      10. Now you can Combine these pdf files in to a single pdf file by selecting all the pdfs and doing a Right Click>Combine files in Acrobat…

      Hope this helps.

      Thanks,

      Ruchi

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices