If you want to edit a data pilot table click on a cell, choose the data pilot option from the data menu then select start…

This will display the data pilot definition screen where you can modify the table as shown in the previous module. When you are done, click the OK button to apply your changes or click the cancel button to leave the data pilot table in its original state.

To delete a data pilot table, click on a cell, select the data pilot option from the data menu then select delete.