Auto-refresh reports

The data in my reports that feed into a dashboard are not automatically updating. I currently have to open the source sheets and refresh the sheet, then open the report and refresh the report, for the change to take effect in my dashboard. I have my personal settings set to auto-save and the dashboard set to auto-refresh every minute. Is there a way to auto-refresh sheets and reports so that I don't have to open them for the dashboard to have the most updated information?

Answers