How do I refresh a report to cover a new date range?

Reports that have been created with a dynamic date range (eg. last 7 days, year to date) automatically update the date range every time they are refreshed.

To change the date range for a report that has been created with a custom date range, go to the report sheet, change the date range, and press the Refresh button (see image below).

If you have lots of reports with a custom date range and want to change the dates for all of them, you can unhide the querystorage sheet and set the start and end dates there.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.