XL2000: Editing Local OLAP Cube Creates New Cube (210777)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q210777

SYMPTOMS

When you edit the local offline OLAP cube (.cub) file for your PivotTable, Excel creates a new .cub file instead of updating the original .cub file.

CAUSE

This problem occurs when you are working with a PivotTable connected to an OLAP data source, and you do the following:
  • You create a local OLAP data cube.

    -and-
  • You reconnect to the OLAP server-based data.

    -and-
  • You save your workbook containing the PivotTable to a different drive and/or folder.

    -and-
  • You edit the local cube file.

WORKAROUND

To work around this problem and update the local cube file, use either of the following methods.

Method 1: Copy the Local Cube to the New Folder

If you save your workbook to a different drive and/or folder, copy the local .cub file from the original folder to the new folder where you saved your workbook. Use the Windows Explorer to locate and copy the .cub file.

Method 2: Reconnect/Edit the Local Cube File

You can reconnect to the local cube and then edit the cube to include any changes. However, if you've made changes to the layout of your PivotTable while connected to the server, including adding new fields (levels) that are not part of the local cube, these layout changes will be lost in your PivotTable. After reconnecting locally, edit the local cube and then re-create the PivotTable for layout changes that were removed.

To reconnect to the local cube, follow these steps:
  1. Click anywhere in your PivotTable.
  2. On the PivotTable menu of the PivotTable toolbar, click Client-Server Settings.
  3. In the Client-Server Settings dialog box, click Local data file and click OK.
To edit the local cube, follow these steps:
  1. Click anywhere in your PivotTable.
  2. On the PivotTable menu of the PivotTable toolbar, click Client-Server Settings.
  3. In the Client-Server Settings dialog box, click Edit local data file.
  4. In the Create Cube File dialog box, add the new dimensions, levels, and measures that you want added to your local offline cube file.
NOTE: If you plan to distribute the PivotTable to other users that may need to make changes to the PivotTable layout, and the PivotTable is connected to an offline cube file (.cub), then you will also need to distribute the offline local cube file with the workbook. You cannot make any changes to the PivotTable without the source data.

MORE INFORMATION

In order to modify the layout or update the data in the PivotTable, the .cub file must be available. When you share or distribute a workbook containing a PivotTable, and the data in the PivotTable is based on a local OLAP cube (.cub), you must distribute the .cub file with the workbook. Because of this requirement, when you create a local .cub file, the file is stored in the same folder as the workbook. The following table lists where the .cub will be saved under different situations: 
   Scenario                   Location of .cub file
   --------                   ---------------------

   Workbook not yet saved.    Drive and folder specified in the 
                              "Default file location" of the Options 
                              dialog box (Tools menu).

   Workbook saved and         Same folder as workbook.
   local .cub created.

   With local .cub file,      Original .cub is updated. 
   workbook saved to          Local .cub is not saved to same folder
   different folder           as the workbook.
   and local .cub edited.

   With local .cub file,      New .cub saved to same folder as workbook.
   reconnect to server-       Original .cub is not updated.
   based OLAP data, save
   workbook to new folder
   and local .cub edited.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbprb KB210777
©2003 Microsoft Corporation. All rights reserved.