Q: When creating a PDF from an Excel spreadsheet (.xls), all workbooks in the spreadsheet are converted into a single PDF. I only wanto to convert one spreadsheet (the active sheet/page). Selecting that option on the "Change Office options..." tab in the
Mike Stokes Jul 25, 2009
This should solve the issue:
1) Open Excel and the current Workbook you want to convert.
2) Select the current worksheet you want to convert.
3) Select File->Print option in the Excel menu and choose the 'Click to Convert II' printer to print to - make sure you select only to print the active worksheet in the Excel print options. NOTE - this option is different from the 'Click to Convert' option.
4) Click 'OK' and this should then send/print only the active sheet to PDF.
- The Click to Convert Support Team