Spreadsheet 123 Excel 2007 FAQs: Change Name

Also learn how to change the pivot table name in Excel 2003/XP/2000/97.

Question:  How do I change the name associated with a pivot table in Excel 2007?

Answer:  Right-click on the pivot table and then select "PivotTable Options" from the popup menu.

When the PivotTable Options window appears, enter the new name for the pivot table in the Name field. Click the OK button. In this example, we've renamed our pivot table to MyFirstPT.