Forum Discussion
Save as PDF
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.
A suggested solution would be to set the print area to the marking (Page Layout - Page setup - Print area)
and save via "Save as" as PDF (select as file type)
Normally, the print area of the active spreadsheet is written into the PDF.
Hope I could help you with these information
NikolinoDE
I know I don't know anything (Socrates)
Thanks for the instructions. It took me some time to work through and experiment with settings.
It would seem my problem had to do with Office365 having disabled the integration of Adobe Acrobat DC also installed on my laptop, which resulted in Excel doing what it wanted to do when 'saving as PDF'
By 'reactivating' Adobe Acrobat DC, printing returned to how I had configured.
The Excel files I use are created from templates I have developed over several years and do include page layout commands. When Office365 chose to disable Adobe Acrobat DC, changing any of the Page Layout setting in an Excel file made no difference to the resulting PDF produced.
- I am pleased that you have found a solution (or a detour :).
I wish you a lot of success with Excel and wish you a Merry Christmas.
