Refreshing Data in Excel

Procedure

  1. To refresh the data that currently displays in the Excel spreadsheet, click the Refresh Data button on the External Data toolbar, as shown in the following figure.
    Figure: Microsoft Excel Refresh Data Button
    • If the External Data toolbar is not available, select Toolbars from the View menu, and then click External Data.
  2. To automatically set refresh intervals, click the Data Range Properties button (the second button from the left) in the External Data toolbar.

What to do next

Refer to the Microsoft Excel online Help for more detailed instructions.