XL2000: Error Message "The cube file <file name>.cub cannot be opened for writing." (230958)
The information in this article applies to:
This article was previously published under Q230958 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.
| Modification Type: | Major | Last Reviewed: | 10/6/2003 |
|---|
| Keywords: | kberrmsg kbnofix kbprb KB230958 |
|---|
|