Printing Excel Spreadsheets to Single PDF Files
Moderators: TrackerSupp-Daniel, Tracker Support, Vasyl-Tracker Dev Team, Chris - Tracker Supp, Sean - Tracker, Tracker Supp-Stefan
-
- User
- Posts: 4
- Joined: Wed Jun 20, 2007 12:20 pm
Printing Excel Spreadsheets to Single PDF Files
I've noticed when I try to print an Excel spreadsheet with multiple sheets or tabs in it to a PDF file, your software creates a separate PDF file for each sheet. This occurs even though the Print Preview shows it as a single multipage output. Is there a way to end up with a single PDF file? Currently I have to print each sheet and then insert the various files into a single PDF document.
-
- User
- Posts: 26
- Joined: Fri Nov 06, 2009 5:36 pm
Re: Printing Excel Spreadsheets to Single PDF Files
I haven't seen this problem. I only select all the tabs and then print.
This is using Excel 2003
This is using Excel 2003
-
- Site Admin
- Posts: 5219
- Joined: Tue Jun 29, 2004 10:34 am
- Location: United Kingdom
Re: Printing Excel Spreadsheets to Single PDF Files
You dont say which version of release you are using - but assuming you are using the Toolbar Addin options available in the Standard or PRO Versions of the PDF-XChange Driver- there is a printer preference settings/TAB called : Excel Options -> 'Print Entire Work Book'
Do you have that set ?
Do you have that set ?
If posting files to this forum - you must archive the files to a ZIP, RAR or 7z file or they will not be uploaded - thank you.
Best regards
Tracker Support
http://www.tracker-software.com
Best regards
Tracker Support
http://www.tracker-software.com
-
- User
- Posts: 4
- Joined: Wed Jun 20, 2007 12:20 pm
Re: Printing Excel Spreadsheets to Single PDF Files
John,
I am using PDF Exchange Pro v 2.0 build 42.3
The toolbar is set as you described - under "Excel Options", the "Print Entire Workbook" box is checked.
I've tried this using the Convert Document to PDF button on the toolbar, and also using the Excel File-Print-Entire Workbook options.
In both cases, I am prompted for a new file name for each worksheet. Using the print command from Excel I can do a print preview, which shows a two page PDF, however when I then tell it to print I am again prompted for multiple file names as described above.
I am using PDF Exchange Pro v 2.0 build 42.3
The toolbar is set as you described - under "Excel Options", the "Print Entire Workbook" box is checked.
I've tried this using the Convert Document to PDF button on the toolbar, and also using the Excel File-Print-Entire Workbook options.
In both cases, I am prompted for a new file name for each worksheet. Using the print command from Excel I can do a print preview, which shows a two page PDF, however when I then tell it to print I am again prompted for multiple file names as described above.
-
- Site Admin
- Posts: 17949
- Joined: Mon Jan 12, 2009 8:07 am
- Location: London
Re: Printing Excel Spreadsheets to Single PDF Files
Hello evander,
You are not using the latest version so I would advise you to upgrade.
As far as I recall there was some issue with Excel sending the separate sheets as separate printjobs - resulting in separate files created by us.
I can not remember now whether this was fixed or the problem stays in excel but please try to upgrade and check for yourself.
Also try what Oldjim suggested - might be the trick to fool excel to output them all at once
Best,
Stefan
You are not using the latest version so I would advise you to upgrade.
As far as I recall there was some issue with Excel sending the separate sheets as separate printjobs - resulting in separate files created by us.
I can not remember now whether this was fixed or the problem stays in excel but please try to upgrade and check for yourself.
Also try what Oldjim suggested - might be the trick to fool excel to output them all at once
Best,
Stefan
-
- User
- Posts: 664
- Joined: Tue Nov 14, 2006 12:23 pm
Re: Printing Excel Spreadsheets to Single PDF Files
Hello Evander,
Possible reason for such behaviour - that you have different "Print quality" value for different Excel sheets. So please, try to set same "Print quality" ("File->Page Setup") in all sheets in workbook.
HTH.
Possible reason for such behaviour - that you have different "Print quality" value for different Excel sheets. So please, try to set same "Print quality" ("File->Page Setup") in all sheets in workbook.
HTH.