AcrobatXPro is not printing all tabs in an Excel Workbook in one PDF File.
Example: an Excel (MS Office 2010) with 13 tabs: The pdf converter may put the first three to six tabs in one pdf file, then each subsequent tab will generate a new pdf file, each tab to be saved one file at a time, until all the tabs have been saved. The single printing request in this case will have generated anywhere from 8 to 11 PDF files rather than one PDF file containing 13 pages.
Using the same file will vary the result. Sometimes the print command will generate three pages in the first file, other times seven, etc. There seems to be no reason for the randomness, the file is unchanged.
The selection to print the entire workbook is correctly selected. The print preview shows that all 13 pages will be printed as one file. The result is different than the preview.
Note: in the Tell Us About Your Software section below the Version Type does not list Acrobat Ver X. So I selected "none".
AcrobatXPro Not Printng All Excel Workbook Tabs
2010-11-17 23:33:06
Answered
My Product Information:
Acrobat Pro, Windows
Acrobat Pro, Windows
2010-11-18 09:36:55
#2
Hi.
Yes using the Macro in Excel, or any other method of distilling the file in AcrobatX.
32 bit Microsoft Office. 64 Bit Windows 7. Acrobat installed as x86 program (32 bit).
Everything else in Acrobat X seems to be working fine except no thumbnail views in Windows Explorer file manager.
Yes using the Macro in Excel, or any other method of distilling the file in AcrobatX.
32 bit Microsoft Office. 64 Bit Windows 7. Acrobat installed as x86 program (32 bit).
Everything else in Acrobat X seems to be working fine except no thumbnail views in Windows Explorer file manager.
2010-11-18 11:44:00
#3
In Excel, under the Acrobat preferences, do you have "Prompt for selecting Excel Sheets" checked?
Are any of your worksheets protected?
Are any of your worksheets protected?
2010-11-18 13:08:07
#4
Hi Lori
Yes: "Prompt for selecting Excel Sheet" is checked.
None of the worksheets are protected. The particular file requires a password to open but no sheets are protected in any way.
Meanwhile, the problem seems to have corrected itself when using the "Create PDF" option on the Acrobat tab in Excel and selecting "Entire Workbook". Previously this failed, but now is working successfully (? beats me ?).
However, the problem persists if attempting to go through the "print file" routine. Attempting to cancel the routine once started (say after printing the first several worksheets as separate pdf files), causes Excel to stop running and Excel closes.
So, it's working now via one path, but not the other.
Anticipating a question: yes, in the print file attempt, the entire workbook is selected. Alternatively, if I try selecting via the "active sheets" , selection the same problems also occur.
I'm sure others will try printing through this path since the option is there in the print options. So it's probably worth resolving even if the other method is proving successful.
Hope this helps.
Yes: "Prompt for selecting Excel Sheet" is checked.
None of the worksheets are protected. The particular file requires a password to open but no sheets are protected in any way.
Meanwhile, the problem seems to have corrected itself when using the "Create PDF" option on the Acrobat tab in Excel and selecting "Entire Workbook". Previously this failed, but now is working successfully (? beats me ?).
However, the problem persists if attempting to go through the "print file" routine. Attempting to cancel the routine once started (say after printing the first several worksheets as separate pdf files), causes Excel to stop running and Excel closes.
So, it's working now via one path, but not the other.
Anticipating a question: yes, in the print file attempt, the entire workbook is selected. Alternatively, if I try selecting via the "active sheets" , selection the same problems also occur.
I'm sure others will try printing through this path since the option is there in the print options. So it's probably worth resolving even if the other method is proving successful.
Hope this helps.
2010-11-18 13:23:00
#5
Accepted Answer
According to the Release Notes for Acrobat X,, this is a known issue:1) When printing an Excel Workbook to Adobe PDF Printer, and selecting the Entire Workbook for printing or multiple Active Sheets, a problem occurs. The user gets prompted for the name of the target PDF multiple times and multiple PDFs are created instead of a single one. The workaround is to use the Excel PDFMaker. [2513126]also,
2) If a user selects more than one worksheet in Excel and then chooses File > Print > Adobe PDF, the error “The printer command is invalid” appears. If only 1 tab is selected, page is printed properly. This problem occurs on 64-bit Windows 2003, using Office 2007. The problem does not occur on 32-bit systems with the same configuration. The Microsoft hotfix corrects the problem. The issue occurs due to bug in GDI. [2609751]
2010-11-18 13:33:43
#6
Thanks Lori. I had not read the release note (thanks for the link), but you described the problem exactly. The workaround seems to be working fine - it's frankly a better path than going through the printer.
Thanks for the feedback.
Best
Thanks for the feedback.
Best
I've updated the Version selector to include Acrobat X - thanks for reminding me.
Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.