Copy link to clipboard
Copied
Hello. In the old version of adobe acrobat pro that i used, i could combine excel files, but only the active sheet that was open in the file. I can not figure out how to do this in the 2020 version. It wantsto use all of the tabs in the excel file. I only want to use the active one to combine to one pdf. I have checked the preferences and the 'combine all worksheets' isnt checked, but it is combing all anyway. Any help would be appreciated. Thanks.
Copy link to clipboard
Copied
Hi Neill
Hope you are doing well and sorry for the trouble. As described, when combining excel files, combine all worksheets' isn't checked, but it is combing all.
Would you mind sharing the version of the Adobe Acrobat you are using? To check the version of the application go to Help > About Acrobat and make sure you have the latest version installed. Go to Help > Check for Updates and reboot the computer once and see if that works for you.
You may also check out the correct answer marked in a similar discussion: https://community.adobe.com/t5/acrobat/how-do-i-merge-only-1-worksheet-from-a-variety-of-excel-files...
If it still doesn't work, please try to repair the installation (Windows Only) and reboot the computer once. Go to Help > Repair Installation.
If it still doesn't work, please try to reset the Acrobat preferences to default as described in the help page: https://community.adobe.com/t5/acrobat/how-to-reset-acrobat-preference-settings-to-default/td-p/4792...
Regards
Amal
Copy link to clipboard
Copied
I have adobe acrobat pro 2020. I have tried several things and can not get it to work. When i add the workbooks to combine, under 'page range' it says 'all sheets'. Can i change that to just active sheets?
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Hi there
We are sorry to hear that. Please check the correct answer marked in a similar discussion https://community.adobe.com/t5/acrobat/how-do-i-merge-only-1-worksheet-from-a-variety-of-excel-files... and see if that works for you.
Regards
Amal