Delete Data from the Web Application

Mark rows for deletion from the web application using the Mark for Delete option in the Table Row Changes menu.

Caution:

Do not attempt to delete rows from your worksheet using Excel commands such as Delete Cells or Delete Sheet Rows. Doing so will not remove the row from the web application.

To mark a row for deletion from the service:

1. Select a cell in the table row that you want to delete from the web application. If you want to select a range of table rows to mark for deletion, hold down your keyboard’s Shift key and select the first and last row in the range of table rows that you want to delete.
2. Click the Table Row Changes menu, then Mark for Delete.

   A Delete message appears in the Change column and the add-in changes the style applied to the data in the table rows, as shown in the following image where three rows in the table are marked for deletion:

   
   Description of the illustration markdelete.png
3. Click Upload Changes.
4. When prompted to confirm pending deletions, click Yes.

   The add-in sends delete requests for each row that you marked for deletion. For each successful deletion, the corresponding Excel row is removed. If the deletion fails, the Excel row remains with an error message.

   
   Description of the illustration excel-deletedrows.png

Tip:

If you change your mind about deleting one or more rows that you have marked for deletion, select the rows and select Unmark Pending Changes from the Table Row Changes menu. Use Unmark Pending Changes before you upload changes from the Excel workbook; the option does not work after the changes are uploaded.