Excel spreadsheet in SAS VA

[triptiagg200]

Hi,

I am trying to build a dashboard in SAS VA from an excel spreadsheet.

I have imported the sheet in SAS VA, but I am not able to refresh the charts when the new row fields are added in the spreadsheet.

Is it possible to refresh the excel data source? 

[Sam_SAS]

Hello,

To update the spreadsheet manually, I believe you would just import the spreadsheet again and select "Replace file" in the import window.

I believe it is also possible to set up a scheduled job to do this every day (or every hour, etc) if you have data admin permissions, but this is not an area of expertise for me.

Sam