Reconnect to an OLAP server

Microsoft Office Excel 2003

Show All Show All

Reconnect to an OLAP server

  1. Click the PivotTable report.

    For a PivotChart report, click the associated PivotTable report.

  2. On the PivotTable toolbar, click PivotTable, and then click Offline OLAP.
  3. Click On-line OLAP, and then click OK.
  4. If prompted to locate the data source, click Browse to find source, and locate the OLAP server on your network.

Note  If the report was created from a data source that connects directly to the offline cube file, you cannot reconnect the file to the server. For information about connecting to the OLAP database server from which the .cub file was originally created, contact the person who created the offline cube file.