ExportAsFixedFormat xlTypePDF

the function ExportAsFixedFormat xlTypePDF does not print images, charts or graphs.

For example

Sub PrintReport()
Dim sPath As String
sPath = "/path/to/myreport.pdf"
Sheet1.ExportAsFixedFormat xlTypePDF, sPath
End Sub

will produce a PDF file, but if the print range contains images ,graphs, etc. they will be omitted.

5 votes

Anonymous shared this idea · March 30, 2018 · Flag idea as inappropriate… · Admin →

completed ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · May 04, 2018

Thanks for reporting this issue. The fix for this will be in the next update (v16.13), which should be released in mid-May.

5 comments

An error occurred while saving the comment

Kevin Brown commented · April 16, 2018 08:56 · Flag as inappropriate

This bug has the potential to greatly negatively impact the value of this product to me. Please fix this ASAP. thanks.

Submitting...
Anonymous commented · April 15, 2018 11:56 · Flag as inappropriate

please fix this bug. Mac users need to use excel too! This is a huge problem.

Submitting...
Anonymous commented · April 10, 2018 10:30 · Flag as inappropriate

Please fix this. It would be beneficial to allow images to print. Really messes up work flow.

Submitting...
Essie Djafarian commented · April 02, 2018 12:18 · Flag as inappropriate

Please fix this bug, it is essential for being able to PDF in order to save on paper and get a proper work flow
Thanks a lot

Submitting...
Anonymous commented · March 30, 2018 14:41 · Flag as inappropriate

I forgot to mention that we are seeing this in 16.11.1 but have been aware of this issue for a few months now.

Submitting...