Convert Excel to PDF - portrait and landscape pages

[Bad...@adobeforums.com]

I'm trying to convert an Excel Workbook to PDF using PDF Maker. Some of the worksheets in the workbook are portrait and some are landscape. When I click the PDF Maker button I'm prompted for a new file name each time the page orientation changes. All I want to do is create a single PDF document with a mixture of portrait and landscape pages.

Does anyone know if this is possible using PDF Maker? I don't see why it shouldn't be possible. Is there a setting in the Job Options that I need to change?

[Doria...@adobeforums.com]

Make sure that the print quality is the same for each page (can't remember if this is enough on its own) ... also if you print to a paper printer and monitor the print queue, you will see that there are multiple print jobs - it is the way that Excel offers itself to the printer.

Make sure that you have the most recent updates for Excel.

[Claudia_...@adobeforums.com]

I have a similar question. I have a landscape formatted page in excel and when I convert it to Adobe, the right hand columns are cut off. I tried creating a new default in Adobe Distiller entitled landscape and with the dimensions changed, but this didn't work.

Seems like there should be a relatively easy way to convert landscape excel to a landscape PDF?

[Bad...@adobeforums.com]

The print quality is the same for each page. Although, I had stumbled across that one before. When I print the report to a Postscript (.ps) file and use the distiller it does keep it in a single PDF. However, it makes the page orientation thew same for all pages so I have to manually rotate the ones that should be landscape. This is really frustrating because shareware products like GSView are able to create the PDF correctly from the Postscript file.

I think my problem is different to yours Claudia. I can create a Landscape PDF and I can create a Portrait PDF. I just can't have a mixture of the page orientations in the same document. You should check the print preview in Excel as it's important for the pages to be set up to print correctly in Excel, e.g. margins before you send the file to a PDF.

[Bad...@adobeforums.com]

Further to my previous posting. I now realise it works okay on OfficeXP it's just my PC with Excel 9 (9.0.3821 SR-1).

[Claudia_...@adobeforums.com]

It prints fine. When I go into page set up in excel, it's set up as a landscape document. How do you create a landscape PDF without the loss of the right hand columns? We've tried it both Office XP and an earlier version of Excel and it doesn't work in either one. We're using Adobe 6.0.

[Bad...@adobeforums.com]

different printers have different 'printable areas' on the paper. You could check the Adobe PDF printer driver by opening your Excel document, go to the file menu, select print and then select from the drop down list the Adobe PDF printer. Now close that window without actually printing anything.

Use Print Preview on your worksheets and you'll be able to see which of the sheets are going to lose the end column. Your choice then is to either reduce column widths or make the left/right margins smaller until the whole worksheet area fits in the preview. You should hopefully then be able to pruduce your document.