Reconnect to a Vision Data Cube in Excel 2007

You can reconnect to a Vision data cube to which you were previously connected.

To reconnect to a Vision data cube, complete the following steps:

  1. In Microsoft Excel, click the Data tab.
  2. In the Get External Data group, click Existing Connections.
  3. On the Existing Connections dialog box, select the connection to the Vision data cube that you previously created and click Open.
  4. On the Import Data dialog box, select the PivotTable Report option and any other appropriate options, and click OK.

    You now see a blank Excel worksheet. The report layout area is on the left side. The PivotTable Field List that contains Vision fields to add to a report is on the right side.