It's not quite clear what you would like help with. Do you want to reload your dashboard with new data from an updated excel file? Or do you need help in modifying an expression for a chart? Please provide more details and, if possible, include a screenshot of what you would like to change. Thanks!
I just want to replace the older excel sheet data with new updated excel sheet.The number of rows and columns everything is same in the older and new data. However few values are getting updated and I want the dashboard to automatically update accordingly .
All,I am concerned about is after uploading the new data will the charts and graph change accordingly to the new data.I want the charts and graph to change as I upload the new data.
Maybe when you deleted the older data and added the new data there may be a possibility to have the syntax error in the sheet as a column name is not available like typo error of column name..etc .
And also have checked the format of the fields before and after the data modified.?
Really it could be dependence on one another.
If you shared your script, it would be easy for us to give you the correct solution.