Add, edit, or delete data

Office PivotTable Lists

  • 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.
  • ShowAdd data

    ShowEdit data

    ShowDelete 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.