The other day, I was trying to print some Excel 2007 worksheets that had my data at the top of the sheet followed by charts made from the data below. The charts had titles included, which showed up fine in Preview, however, when I actually printed, the titles were missing! Very strange indeed!
After some digging around, it seems that Office 2007 Update KB2596596 is the cause of the problem. At first, the only solution I was able to find said to uninstall this update and that would fix the Excel printing problem, but I wasn’t satisfied with that.
After some further digging, I found out that Microsoft has released a Hotfix that fixes the problem. (In Microsoft parlance, a Hotfix is a patch that will fix an issue that hasn’t undergone a full suite of testing.) KB2597962 can be requested from Microsoft (i.e. they’ll send you a download link in email, since it’s an unsupported file) by going to the KB2597962 article and clicking on View and Request Hotfix Downloads. Fill out the form and acknowledge the fact that the Hotfix hasn’t been fully tested, and you’ll have a shiny download link in your inbox in no time.
For what it’s worth, I installed the Hotfix on five machines and it has caused me no trouble at all.