Share via

Huge difference between "Print as PDF" or "Export as PDF"

Anonymous
2020-07-29T22:55:26+00:00

I wanted to automate the Printout of some pages as PDF so i added VBA Code to export Sheets as PDF.

But the given Quality for the export is ..... lets say.. weak!

If i select "Print" -> "Microsoft Print to PDF" the quality is way better.

Lines and Fonts in an export are much thicker and with much lower dpi.

Is there a way to bring the export function to the same level as the Real Print to pdf has?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-30T08:16:18+00:00

    Hi Arck,

    thanks for your reply. This behavior is known by a lot of users.

    If you look out for "Excel pdf export" you will find hundreds of users thta complain about it. Also within this forum: 

    https://answers.microsoft.com/en-us/msoffice/forum/all/excel-to-pdf-poor-image-quality/7de92121-bffb-47ce-af20-f7ed79534b22

    Here i attach the Screenshot of the bad versus the good quality:

    Left one is the print and right one is the export.

    It does not change if i do the export manually or with VBA.

    It just seems to use different dpi.

    Lines and Text in the Export are much thicker.

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-08-03T17:59:01+00:00

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2020-07-30T10:31:51+00:00

    Newest Office 365.

    Normal channel (no insider)

    Office Version 2006 (Build 13001.20384)

    Excel for M365 MSO (16.0.13001.20338) 64bit

    And i createda new Excel that i can share.

    0 comments
  4. Anonymous
    2020-07-30T09:27:51+00:00

    Hi Norman,

    Thanks for the clarification, and we're sorry for the inconvenience to your work.

    Based on the screenshot your provided, we can see that the outputs of "Print" and "Export" are indeed quite different, in this case, would you mind sharing this file with me via Private Message as I mentioned above, we'll further investigate it to figure out the cause, you can click here to check your inbox.

    Besides, I'd like to know which version of Excel you are using, it would help us to know if it is a issue only affects certain version, please provide a complete screenshot of the Product Information, as shown below, please note to mask your email address, your patience and cooperation will be highly appreciated.

     

    Best Regards,

    Arck

    0 comments
  5. Anonymous
    2020-07-30T03:37:02+00:00

    Hi Norman,

    Thanks for using Microsoft products and posting in the community, I'm glad to offer help.

    According to your description, I've tested on my side, whether using "Print > Microsoft Print to PDF" or "Export > Create PDF/XPS Document", the output PDF are of good quality.

    In your case, please try to export your workbook as DPF without using VBA to check if there will any difference, if it works well when exporting without using VBA but the issue appears when using VBA to export it, the problem could be related to VBA.

    If the issue persists even you don't use VBA to export the workbook, please check whether other workbooks including the newly created ones have the same problem, if so, you may need to perform an online repair to check the outcome: Repair an Office application

    If the issue only affects one specific workbook, would you mind sharing the problematic workbook with me via Private Message for further investigation? You can click here to check your inbox.

    Please feel free to let me know if there is any progress, I'll continue to help you.

    Best Regards,

    Arck

    0 comments