XL2000: "Cannot connect to the data source..." Error Refreshing OLAP PivotTable

• Microsoft Excel 2000

SYMPTOMS

When you refresh your PivotTable report, Microsoft Excel may appear to stop responding. After a few minutes, you receive the following error message:

Cannot connect to the data source
'Cannot instantiate MSOLAPUI prompt dialog component.'.

CAUSE

This problem occurs when the following conditions are true:

• Your PivotTable report was created using data stored in an Online Analytical Processing (OLAP) database.
  
  -and-
  
  
• You used the Create Cube File wizard to create a local OLAP cube.
  
  -and-
  
  
• Your PivotTable report is currently using the local OLAP cube as its source data.
  
  -and-
  
  
• You are currently unable to connect to the OLAP database used to create your PivotTable report.

WORKAROUND

You must reconnect to your network in order to refresh your PivotTable report.

MORE INFORMATION

When you base your PivotTable on a local cube file, you have the flexibility to manipulate your PivotTable when you are not connected to your network. However, you cannot refresh the data in the PivotTable because the refresh operation queries the original source data on your network, not the local cube file.

Additional query words: XL2000 slicer dcube tensor

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