What happens when choosing to dynamically highlight evaluated cells when adding a Cube View Connection?

What happens when choosing to dynamically highlight evaluated cells when adding a Cube View Connection?

• A. This option auto-resizes column widths based on the settings from the Cube View users choose
• B. This option will highlight a cell if the formula reference has changed without having to refresh a Spreadsheet
• C. This option allows users to enter formulas in the Cube View and retain those formulas pre-submission and post-submission of the sheet or workbook
• D. This option will remove all formatting on add

Answer: (B)

When you enable dynamic highlighting for evaluated cells with a Cube View Connection, the worksheet visually marks cells whose formula references to the cube data have changed. This means you can see, in real time, which cells have recalculated because the underlying cube values changed, without needing to manually refresh the spreadsheet. This immediate visual cue helps you verify data updates and track how the Cube View affects results as soon as changes occur. The other options describe unrelated features—auto-resizing column widths, entering and retaining formulas through submissions, or removing formatting—which don’t provide the live indication of changed formula references that this highlighting offers.

When you enable dynamic highlighting for evaluated cells with a Cube View Connection, the worksheet visually marks cells whose formula references to the cube data have changed. This means you can see, in real time, which cells have recalculated because the underlying cube values changed, without needing to manually refresh the spreadsheet. This immediate visual cue helps you verify data updates and track how the Cube View affects results as soon as changes occur.

The other options describe unrelated features—auto-resizing column widths, entering and retaining formulas through submissions, or removing formatting—which don’t provide the live indication of changed formula references that this highlighting offers.