I'm using excel 2003 and Acrobat 6.0, and when I try to create a PDF file from multiple tabs, it's only creating pages for a couple of tabs and I'm prompted for new file names for the remainder of tabs (sometimes multiple times, depending on the number of tabs I'm trying to create a PDF from). I presume there's a setting that will allow me to create one file for all the tabs I've selected?
Sometimes when you have varying print settings for your worksheets Acrobat cannot correctly interpret the way Excel sends multiple print jobs. Make sure that the print quality setting is the same for all of the worksheets in the workbook.
1. In Excel, hold down the Ctrl key (Windows) or the Shift key (Mac OS), and select all of the sheets in the Excel workbook.
2. Choose File > Page Setup > Page > Print Quality, and select a print quality setting. Adobe Technical Support recommends that you select 600 dpi, which is the default setting for the Adobe PDF and Acrobat Distiller printers.
Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.