---
url: /excel-addin/reporting.md
description: >-
  Provides multiple commands that enables the access to data within the
  connected instance.
---

# Reporting

Provides multiple commands that enables the access to data within the connected instance.

## Explore Reports

Provides an overview of the connected instance.

The various models workviews, cubes, dimensions, and variables will be displayed. Provides the ability to access workviews included within an application.

![Explore Reports](/excel-addin-explore-reports.png)

Right clicking on a workview will give the following options.

* **Open as Workview:** This will open the the workview as a [Live Workview](/excel-addin/live-workview.html) in excel.
* **Open with Formulas only:** This will open the workview with [CubeGet](/excel-addin/cubeget.html) functions to retrieve the values from MODLR. This is the default action when double clicking.
* **Open with Values only:** This will open the workview with values of the workview, and no MODLR functions.

![Explore Reports Options](/excel-addin/excel-addin-explore-reports.png)

## Refresh Worksheet and Workbook

Refresh the selected Both items are functionally the same.

Refresh Worksheet refreshes MODLR Excel Add-in functions in the current worksheet.

Refresh Workbook refreshes MODLR Excel Add-in functions in the current workbook.

![Refresh](/excel-addin-refresh.png)

## Strip Functions

Strips Excel Add-in functions and leave values in the place of previously functions driven cell.

Can be executed for the current:

* selection
* worksheet
* workbook

![Strip Functions](/excel-addin-strip-functions.png)

## Explain Value

Provides an explaination of the selected cell containing a single [CubeGet](cubeget) or [CubeGetFirst](cubegetfirst) function.

* Leaf Explain Value Example

![Leaf Drill Example](/excel-addin-explain-value-n-level.png)

* Consolidation Explain Value Example

![Consolidation Drill Example](/excel-addin-explain-value-consolidation.png)