Yes, there is a way to remove "Sum of" from pivot tables in Excel 2007. Here's how:

1. Click on any cell within the pivot table.
2. In the PivotTable Tools ribbon, click on the Options tab.
3. In the Active Field group, click on the Field Settings button.
4. In the Value Field Settings dialog box, click on the "Number Format" button.
5. In the Format Cells dialog box, click on the "Custom" category.
6. In the "Type" field, delete the "Sum of" text and any other unwanted text.
7. Click OK to close all dialog boxes.

Now, all the values in the pivot table should display without the "Sum of" text. If you have multiple values in the pivot table, you can repeat these steps for each value.