Standard Data Refresh

With the standard data refresh, pivot tables and charts display cached data which is loaded from stored data to load data more quickly. Datasets and table views do not use cached data. Datasets display only real-time data which may take longer to load results.

Note:

You are using the standard data refresh when the Cached Data in Datasets is not enabled. For more information about this feature, see Optimized Data Refresh.

This caching process provides better performance by returning results faster. However, these results might not display the most current data. To find out when the data was last refreshed in your workbook, verify the time displayed in the Last updated field, in the upper-right corner of the Viewer. To better understand the default caching process and how to clear the cache manually, see the following topics:

Related Topics