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

[Guest]

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

[sb116]

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

[Guest]

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

[ruchi_agrawal_adobe_2012 · Accepted solution]

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

[Guest]

Hi Ruchi

Thanks for your reply. Unfortunately before I posted my query I had already gone to Edit>Preferences>Convert to PDF>Microsoft Excel>Edit Settings and ensured the "Convert entire Excel workbook" wasn't checked.

It has only happened when I was using Windows 10 and the new Adobe Acrobat Pro PC (and my work place is moving to this environment very soon).

It doesn't happen in Windows 7 using Adobe Acrobat X Pro.

Thanks

Julie-Anne

[dangSunrise]

I agree with you Julie. What is the purpose of having the ability to uncheck the box when it will be ignored?