Cannot convert a EXCEL file with marco to pdf file

We would like to convert a EXCEL file (including 10 spreadsheets) with marco to pdf file. But we just convert the first spreadsheet of the EXCEL file to the pdf file. Could you let me know how can fix it? Thx.

Make sure that all worksheets have the same Page Setup settings - particularly the Print Quality setting.

This is typical behaviour from Excel. You could also try printing to a PostScript file and converting that to PDF with the Distiller.

In addition to Dorian's suggestion to making sure all the worksheets have the same print quality settings, i.e.: 300 dpi or 600 dpi, make sure that when you call up the file to print, to "print all worksheets"

Bob

Thank you for your suggestion. I can do it when I change the print quality settings for all worksheets. Thanks again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 3rd November 07:28 birdie_chan External User Posts: 1	Cannot convert a EXCEL file with marco to pdf file We would like to convert a EXCEL file (including 10 spreadsheets) with marco to pdf file. But we just convert the first spreadsheet of the EXCEL file to the pdf file. Could you let me know how can fix it? Thx.

2 8th November 12:23 dorian_grey External User Posts: 1	Cannot convert a EXCEL file with marco to pdf file Make sure that all worksheets have the same Page Setup settings - particularly the Print Quality setting. This is typical behaviour from Excel. You could also try printing to a PostScript file and converting that to PDF with the Distiller.

3 8th November 12:23 bad_bob52 External User Posts: 1	Cannot convert a EXCEL file with marco to pdf file In addition to Dorian's suggestion to making sure all the worksheets have the same print quality settings, i.e.: 300 dpi or 600 dpi, make sure that when you call up the file to print, to "print all worksheets" Bob

4 9th November 16:01 birdie_chan External User Posts: 1	Cannot convert a EXCEL file with marco to pdf file Thank you for your suggestion. I can do it when I change the print quality settings for all worksheets. Thanks again.