This Blog is a supplement to my website. Please also visit:

Wednesday, April 11, 2012

Office 2007 Excel Graph Data Missing on Print Jobs

A customer of mine had an issue with printing a monthly report from Excel that contains charts and graphs.  The data on the graph did not show on the print out, but it did show correctly when doing a Print Preview.

In their case, one of the pages contained four graphs on the page.  The odd thing is that when you print the worksheet two of the four graphs had data and the other two didn't.  This behavior also happened when printing to several different models of printers and even when printing to Adobe PDF.

The other oddity is that this same spreadsheet worked correctly for some of my users, while it didn't for others.

In the end I discovered this issue was isolated to those that had Microsoft Office 2007.  Those running Office 2003 were not affected.  Further I found this is caused by a Microsoft Patch that was issued in December 2011.  Removing this patch (KB2596596) corrected our issue.

This is what the graph looked like when it printed incorrectly:

This is how the graph is supposed to look:

Again, just remove the patch called KB2596596 (see highlighted below)

Note: Some of the machines were running MS Office 2007 Basic Edition and some were running MS Office 2007 Enterprise Edition.  Same patch for both.

As always I'm hoping this will help someone else fighting this issue.

1 comment:

  1. Thank you for this post! I have been trying to figure out the cause of this issue for weeks.