...
- Open the saved Excel spreadsheet
- Navigate to the Data tab and click 'Refresh AllRefreshl'
OR
Right click any cell containing data from USAS-R and click 'Refresh'Enter username and password for USAS-R.
Warning It is common for this step to take time to load - specifically when pulling a large set of data (full Fiscal Year). Excel will indicate in the bottom left corner of the window that it is running a query in the background. Note It is also important to note that the report parameters saved using Save and Recall must remain active and unchanged in USAS-R. Any changes to the saved report parameters used for the report link will impact the data in the spreadsheet.
...