Refresh an offline cube file

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. If you aren't sure what original database was used to supply the data for the cube, consult the person who created the PivotTable or PivotChart report 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.