The reason Excel 2007 Pivot Tables show the text "Column Labels" and "Row Labels" in the header rather than the actual name of the dimension fields in use is because it is a default setting in Excel. However, you can easily change this setting to show the actual names of the dimension fields.

Here are the steps to show the actual names of the dimension fields in Excel 2007 Pivot Tables:

1. Click on any cell within the Pivot Table to activate the "PivotTable Tools" tab in the ribbon.
2. Click on the "Options" tab in the ribbon.
3. In the "PivotTable Options" group, click on the "Options" button.
4. In the "PivotTable Options" dialog box, click on the "Display" tab.
5. Under the "Display" tab, uncheck the "Display field captions and filter drop downs" option.
6. Click on the "OK" button to save the changes.

Now, your Pivot Table should show the actual names of the dimension fields in the header instead of "Column Labels" and "Row Labels". This setting will also apply when you print the Pivot Table.