Delete Data from All Data Worksheets

The Excel2007Sample.xlsm file contains sample data. This sample data can be deleted from data worksheets with this activity.

Note: This activity presumes that the Excel Uploader is open.

Activity Steps

1. Select the CreateDataTables worksheet.

   Note: The keyboard shortcut to select the CreateDataTables worksheet is Ctrl+K.

2. Click the Delete All Data cell button (L21).

   Data in the data worksheets is deleted.

   The L24 cell displays the status of the deletion.

   Note: This activity also clears any data in the Lists and AccountSubConceptLists worksheets, which are used for reference purposes. These object lists can be updated with current data from the MineMarket database.