Microsoft KB Archive/230958

= XL2000: Error Message "The cube file .cub cannot be opened for writing." =

Article ID: 230958

Article Last Modified on 10/6/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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 .cub cannot be opened for writing.

Where .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 .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 kbnofix kbprb KB230958

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.