Include different data in an offline cube file

Saving a revised offline cube file can be time consuming, and you cannot do other work in Excel while the file is being saved. 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 OLAP server database that supplied the data for the offline cube file.
2. Click a PivotTable report that's based on the offline cube file.

   For a PivotChart report, click the associated PivotTable report.

3. On the PivotTable toolbar, click PivotTable, and then click Offline OLAP.
4. Click Offline OLAP, and then click Edit offline data file.
5. Follow the steps in the Offline Cube Wizard to select different data for the file. In the last step, specify the same name and location as the existing file that you are changing.

Note  To cancel saving the file, click Stop in the Create Cube File – Progress dialog box.

In Query, open the .oqy file created by the OLAP Cube Wizard, and then use the wizard to change the .cub file. You can delete and reorganize fields, but you cannot add more fields to this type of cube. For full instructions, see Help in Microsoft Query.