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 new Excel data should be identical to the previous data structure.

• 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 add a new Customer Id (8) in the Excel and overwrite the existing Excel.

Before overwriting, the data is as shown below.

We have added one more Customer Id in the local Excel and we will overwrite the existing Excel with this newly added Customer Id 8 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.