Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the saved Excel spreadsheet
  2. Navigate to the Data tab and click 'RefreshlRefresh'
    OR
    Right click any cell containing data from USAS-R and click 'Refresh'





    1. 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.


...