XL2000: Client-Server Settings Error "Problems Obtaining Data"

When you connect to your local data file (.cub) for a PivotTable created from an offline OLAP data cube, the following error message appears: When you click OK, the following error message appears:

This problem will occur when you do the following in a PivotTable created from an OLAP server:

• You create a local data file (.cub).
  
  -and-
• You reconnect to the OLAP server.
  
  -and-
• You add new fields to your PivotTable that are not part of the offline cube.
  
  -and-
• You reconnect to your local data file (.cub).

If you add fields to a PivotTable from the OLAP server, and those fields are not part of the original local .cub file from which the PivotTable was created, you must edit the local .cub file and add the new dimensions, levels, and measures. You cannot reconnect to the local .cub file if the PivotTable contains new fields that are not part of the local data file. To edit the local data file, follow these steps:

1. In the Client-Server Settings dialog box, click Edit local data file.
2. Click Next.
3. Click the dimensions and levels you want to add to your local data file.
4. Click the items for each level in your cube and click Next.
5. Click Finish to save the .cub file.

After creating a local data file (cube) for a PivotTable, you have the ability through the Client-Server Settings dialog box to disconnect from and reconnect to the OLAP server. When creating the local cube file, you decide which items to include, and then the dimensions and measures that are currently in the PivotTable will be saved. The PivotTable only allows you to use the dimensions and measures available within the local cube file.

However, connecting back to the OLAP server will provide all of the items from the server's cube file. If you add a field to your PivotTable that was not originally saved in the local cube file, you cannot switch back from the OLAP server to the offline cube without editing the local cube file, and adding the new fields (levels and measures) to the local cube file.

For more information about OLAP cube files, click Microsoft Excel Help on the Help menu, type About creating a PivotTable or PivotChart report from OLAP data in the Office Assistant or the Answer Wizard, and then click Search to view the topic.