After creating a data source, you can manage it in the portal. You can upload new Excel data to completely overwrite the previous data with the help of the Overwrite Data option as shown below.

Important Points

• You can overwrite only the local Excel data source.

• The data structure of new Excel should be identical to the data structure of old Excel.

• The Excel file used for overwriting should have the same password as when the Excel data source was created.

• After performing an overwrite operation on a data source, revisions on the Info page will not retain the history.

Steps to overwrite an Excel data source

In this example, we will edit the Name and Quantity data for the Customer Id 7 and 8 in the Excel and overwrite the existing Excel.

Before overwriting, the data is as shown below.

We have edited the Name and Quantity data for the Customer Id 7 and 8 in the local Excel and we will overwrite the existing Excel with this new data by following the steps below.

1. Select the Excel Data source that you want to overwrite, click More and select the Overwrite Data option.

   
   

   
   

   
   

   The Overwrite Data dialog box is displayed.

   
   

   
   

   
   

2. Select the Excel file to overwrite the data and click the Overwrite button.

   
   

   
   

   
   

   A confirmation message is displayed. Click Dismiss on the message box.

   
   

   
   

   
   

   The data is overwritten as shown below.

   
   

   
   

   
   

   Note: After creating an Excel data source, if any data is changed, you cannot fully overwrite the data by using the Append option. You need to reconfigure the data source, and then upload the file again. The Append data option cannot meet the requirement of overwriting the data. Whereas, the Overwrite option can fully overwrite the data without reconfiguring and uploading the file again.