Exporting Excel to Pdf, MS Excel behaves wrongly for A4 paper size

Hi Guys,

While converting Excel file which has A4 has paper size to Pdf. The Exported pdf has a wrong size of paper.

i.e paper size in Excel is  A4(8.27' * 11.69') but the Exported pdf has (8.50' * 11.00') which is letter.

What is reason the behind this implementation?

But this scenario is working fine in Word Document.

Can any one help me out?


March 7th, 2015 6:47am

Are you creating the PDF with the native excel functionality ("Save as PDF") or with a PDF printer (-> Print -> select PDF printer)?
  • Marked as answer by dillibabu_n 3 hours 28 minutes ago
  • Unmarked as answer by dillibabu_n 3 hours 28 minutes ago
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2015 9:38am

Hi,

In regarding of the issue, please provide us more information to assist you better.

  • Which Office version are you using? Excel 2013 or other?
  • How did you export the Excel sheet as PDF? Used Acrobat Add-in for Excel or build-in feature(save as)?

Scenario One

If you used the Acrobat Add-in for Excel and then clicking on Create PDF, please try the methods below:

  • In Excel, go to File > Options > Advanced> Under General section, uncheck Scale content for A4 or 8.5 x 11 paper size >click OK.
  • Open the Excel file you want to convert to PDF, go to File > Save as.
  • Change which printer was associated with the file

http://answers.microsoft.com/en-us/office/forum/office_2010-outlook/excel-2010-to-adobe-pdf-page-size-issue/d15d0bef-dd11-4eca-96e4-30bfd8edbdcc

Scenario Two

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.

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

http://support.microsoft.com/kb/2519799

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

March 10th, 2015 7:46am

Hi Guys,

While converting Excel file which has A4 has paper size to Pdf. The Exported pdf has a wrong size of paper.

i.e paper size in Excel is  A4(8.27' * 11.69') but the Exported pdf has (8.50' * 11.00') which is letter.

What is reason the behind this implementation?

But this scenario is working fine in Word Document.

Can any one help me out?

Free Windows Admin Tool Kit Click here and download it now
March 12th, 2015 11:57am

Hi George,

Scenario one resolved my issue . Thanks for your support.

Regards,

Dilli babu

March 12th, 2015 11:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics