Visual Explorer enables users to transfer data from the Visual Explorer interface to an Excel worksheet at any time. 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 or click .
To retrieve data into a new worksheet within the active Excel workbook, select Update Excel (New Worksheet) or click .
View the data in the Excel worksheet.
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 new 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 new worksheet within the currently active Excel workbook.
See the online help that is accessed from the Help menu in Visual Explorer.