When exporting an Excel spreadsheet as a PDF file, the page dimensions may change


Symptoms


When using Excel if the page break size is altered to modify the print area, on exporting the Spreadsheet to PDF, the resulting page size may differ than what is set in the original document.

Cause


The problem is that when a PostScript printer is selected as the default printer for Excel, the application does not scale the sheet size. This behavior is because with PostScript the output device does the scaling rather than Excel.

Resolution


To workaround this behavior, choose a PCL type printer as the default prior to exporting the document.