Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Differences between Report and Refresh

This article refers to versions of the Jet Excel add-in prior to version 2018 R2.  For newer versions see Differences between Run and Run from Cache.

When the Refresh button is pressed...


The Jet Excel add-in will pull new/current data from the database.  This is the best option if you want the most up-to-date information.


When the Report button is pressed...


The Jet Excel add-in will use cached information that was created from the last time you ran the report from your current Excel session.  This means that the information will be returned quickly, but will not reflect any data that was entered in the database since you previously ran the report during your current Excel session.

During report generation, the result of each Jet function is saved in a cache.  If data has changed in your database and you click Report, the report will not update the values, since the old values are stored in the cache.  To see updated values from your database, push the Refresh button or clear the cache by closing Excel and then re-opening your report.


Was this article helpful?
0 out of 0 found this helpful