If you want to show tabular data in Excel dashboards, Excel’s Camera tool is the most useful tool you can have. However, Excel 2010 has a bug that appears to limit the usefulness of Camera tools.
(If you don’t know what the Camera tool is all about, I devote a chapter to it in Dashboard Reporting With Excel.)
Here’s the bug: When you print a page that includes the Camera object, Excel sometimes adds row and column titles to the image, so that it looks something like the following figure in your printed results:
Honestly, I don’t know what causes Excel to display these headings. But I do know how to stop them. This figure shows the problem:
That is, in the worksheet that contains the original table (not the linked picture of the table) you’ll find the Print option checked in the Sheet Options group. Just uncheck it and then save your workbook.
It’s a simple fix, but a difficult one to discover.
