What does the Dynamically Highlight Evaluated Cells setting apply to when creating a Cube View Connection?

What does the Dynamically Highlight Evaluated Cells setting apply to when creating a Cube View Connection?

• A. Highlighting a cell if the formula reference has changed without having to refresh a spreadsheet
• B. Highlighting all cells with Dynamic Calculations within a Cube View
• C. Highlighting cells with Excel styles applied only
• D. No highlight option exists

Answer: (A)

Dynamically Highlight Evaluated Cells focuses on visibility of dependency changes in a Cube View Connection. When this setting is on, a cell is highlighted if the formula reference it uses has changed, so you can instantly see which parts of the view are affected without having to refresh the spreadsheet. This is about tracking changes in what the cell’s formula references, not about highlighting every dynamic calculation or only applying Excel styles. It provides immediate, automatic visual feedback for changed references, helping you audit and verify how the Cube View is reacting to data or formula changes.

Dynamically Highlight Evaluated Cells focuses on visibility of dependency changes in a Cube View Connection. When this setting is on, a cell is highlighted if the formula reference it uses has changed, so you can instantly see which parts of the view are affected without having to refresh the spreadsheet. This is about tracking changes in what the cell’s formula references, not about highlighting every dynamic calculation or only applying Excel styles. It provides immediate, automatic visual feedback for changed references, helping you audit and verify how the Cube View is reacting to data or formula changes.