1. Under the Data Source Pane, click on ‘Data’ and choose the Excel File that you wish to update or replace. Choose
‘Edit Connection’.
2. This will prompt you to choose the new Excel file and click ‘Open’.
NOTE: When replacing/updating an Excel File, make sure that the fields are named the same as the previous file, therefore, the charts already created in the workbook will update correctly.
3. Find the desired Excel file and select the file from your computer.