Add, edit, or delete data

Office PivotTable

Show All

Add, edit, or delete data

If you can't add, edit, or delete data in a PivotTable list, it means one of the following:

  • The designer of the Web page has set properties to prevent you from adding, editing, or deleting data.
  • The field you are trying to edit is a read-only field, and does not support edits.
  • The underlying table does not have a primary key.

Add data

Edit data

Delete data


  • When entering data for a field that has a number format applied to it, you need not type formatted data.¬†When you leave the cell, the format will be automatically applied to the cell contents.
  • Only detail cells can be edited directly in the PivotTable list. To change a caption or the title, use the Commands and Options dialog box.