Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When I print the whole workbook to eDocPrinter PDF Pro from Excel, I am prompted with SaveAs dialog several times, i.e., it was printed to several PDF files. Why?

April 26, 2017dialog edocprinter Excel PDF print Pro prompted saveas times Workbook

0

Posted

When I print the whole workbook to eDocPrinter PDF Pro from Excel, I am prompted with SaveAs dialog several times, i.e., it was printed to several PDF files. Why?

1 Answer

0

Posted

Excel will start different printing job (i.e. different PDF file) if the “Print Quality” (resolution) of “Page Setup” of Excel menu is different among worksheets. Select all worksheets and set the Print Quality to the same for all sheets. After this, users can print whole workbook suffering this problem into a single PDF file.