There are two ways to program a spreadsheet to update ... Select the "Refresh Every" check box and enter the number of minutes you want Excel to wait between automatic updates.

How to refresh the sheet name Table in Excel When you add, delete, or rename sheets, you’ll need to update the list. First, save the workbook. Then, right-click the list and choose Refresh from ...