Excel data drill down

Data drill down

BCE Excel functions are supported from BCE v1.8.0 using local and online editions of Excel.

A data drill down option allows the underlying data to be inspected from highlighted cell id it has been sourced from BCE.

From the BCE menu panel, select 'Actions / Data Drill Down' to open to the following:

The 'View in BCE' option becomes active whenever a cell is selected that contains BCE data.

Details of the cell selected and the formula content are displayed for reference:

Clicking on the 'View in BCE' button will open the underlying data in a separate tab:

See Using BCE Excel Functions

Did this answer your question?

Powered by HelpDocs (opens in a new tab)