What is the difference between a vision statement and a mission statement? What is the difference between sight and vision? What is the difference between a dream and a vision?
1 If the column you want represented in your pivot table does not already exist in the source data worksheet, you will need to insert a column by right clicking on an existing column and choosing Insert Column from the popup menu.  If you added a column to your source data, populate that column with the relevant data.
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. Share this page: Advertisement.