The two main options for running reports using the Jet Excel add-in are Run and Run from Cache.
There are subtle but important differences between these two options.
When selecting Run, the Jet Excel add-in will retrieve new/current data from the database. This is the best option if you want the most up-to-date information.
Run from CacheWhen selecting Run from Cache, the Jet Excel add-in will use cached information that was saved from the last time you ran the report within your current Excel session. This means that the information will be returned quickly, but will not reflect any data that may have changed in the database since you previously ran the report (during your current Excel session).