Show All

Hide All

Refreshing a cube file, which recreates it with the most recent data from the server cube, can be time consuming and require a lot of temporary disk space. Start the process at a time when you do not need immediate access to other files, and make sure you have adequate disk space to resave the file.

1. Make sure you are connected to your network and can access the original server database that supplied the data in the offline cube file (offline cube file: A file you create on your hard disk or a network share to store OLAP source data for a PivotTable or PivotChart report. Offline cube files allow you to keep working when you are not connected to the OLAP server.). If you aren't sure what original database was used to supply the data for the cube, consult the person who created the PivotTable (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.) or PivotChart report (PivotChart report: A chart that provides interactive analysis of data, like a PivotTable report. You can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and by showing or hiding items in fields.) or the cube.
2. Click a report that's based on the offline cube file that you want to refresh.
3. On the PivotTable toolbar, click Refresh Data .

   To cancel a refresh in progress, press ESC.

Note  When you work with OLAP data offline, do not put the .cub file in the Windows briefcase. Excel does not use the briefcase to synchronize the offline cube file with the server database.