XL2000: Error Message "The cube file <file name>.cub cannot be opened for writing."

ID: Q230958

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you attempt to create a local OLAP cube file, the following error message appears:

Microsoft OLE DB Provide for OLAP Services:
The cube file file name.cub cannot be opened for writing.

Where file name.cub is the name of an offline OLAP cube file.

NOTE: If you try to refresh your PivotTable, you may receive the following error message:

The cube file file name.cub cannot be opened for writing.

CAUSE

This problem occurs when you do the following:

You create multiple PivotTables from a single cube file.

-and-

You attempt to either refresh your PivotTable or create an offline local cube file, when more than one PivotTable is connected to the offline cube.

WORKAROUND

In order to refresh data in your PivotTable or create a local cube file, the first file to access the offline cube file must be closed. Only one PivotTable can have write access to the cube; therefore, you can modify or refresh only the first PivotTable opened. You cannot modify or refresh all subsequent PivotTables until you close the first.

Additional query words: XL2000

Keywords : kberrmsg
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb