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:
- In Microsoft Excel, click the Data tab.
- In the Get External Data group, click Existing Connections.
- On the Existing Connections dialog box, select the connection to the Vision data cube that you previously created and click Open.
- 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.