Retrieving Data Using Visual Explorer

Visual Explorer enables users to transfer data from the Visual Explorer interface to an Excel worksheet. After you create a view of data in Visual Explorer, you can transfer the underlying data to the active Excel worksheet by using the Update Excel command.

You can also transfer data to a worksheet within the active Excel workbook using the Update Excel (New Worksheet) command.

To retrieve data from Visual Explorer into a worksheet in Spreadsheet Add-in:

In Visual Explorer, select File.
Perform one action:
- To retrieve data into the active worksheet, select Update Excel.
- To retrieve data into a worksheet within the active Excel workbook, select Update Excel (New Worksheet).
View the data in the Excel worksheet.

Notes:

When you select Update Excel, Visual Explorer sends data to the Excel worksheet that was previously used if the "Update Excel (New Worksheet)" was invoked. If no worksheet is available, data is sent to the Excel worksheet from which the Essbase connection being used by Visual Explorer was originally established. If the original Essbase connection was not established from Excel, the Update Excel command is not selectable, and users must use the "Update Excel (New Worksheet) command.
When you select the Update Excel (New Worksheet) command, Visual Explorer sends data to a worksheet within the active Excel workbook.
See the online help that is accessed from the Help menu in Visual Explorer.