Skip to main content
M
michaelm87971088
New Participant
August 10, 2017
Question

Exporting Excel to .pdf doesn't match Excel print

  • August 10, 2017
  • 1 reply
  • 1447 views

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

This topic has been closed for replies.

1 reply

jane-e
jane-e
Community Expert
August 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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices