Exporting Excel to .pdf doesn't match Excel print

Report · Aug 10, 2017

I have an Excel file that allows the user to export a number of worksheets to a .pdf file.

Each of the sheets consists of a number of charts and up to 4 tables of data.

As there can be between 1 & 4 tables and any number of rows in each table, the user has the ability to change the page break location sin order to ensure any of the 4 possible tables are not split between 2 sheets.

When the output is printed via Excel all the print ranges, margins, etc are set to utilise as much space on the output as possible. Also, headers and footers are included. When this is exported to a .pdf, the whole output doesn't match the Excel output.

As the .pdf is t be sent externally to clients it need to be exactly the same as the Excel print/output.

Can anyone help with this as I am struggling to find anything remotely close to a solution.

TIA

Report · Aug 10, 2017

michaelm87971088 wrote
When the output is printed via Excel all the print ranges, margins, etc are set to utilise as much space on the output as possible. Also, headers and footers are included. When this is exported to a .pdf, the whole output doesn't match the Excel output.

Are you using the Acrobat tab to create the PDF and looking in Preferences on the Acrobat tab first?

Or are you doing as you say—printing via Excel [to PDF].

Printing to the Adobe PDF printed it obsolete technology. Try the PDFMaker (the Ribbon) and report back.