What happens to standard formatting within a Cube View when the sheet or workbook is refreshed?

• A. The user will be prompted to save the formatting against the Cube View.
• B. The formatting will be lost within the Cube View.
• C. The formatting will still be retained in the Cube View.
• D. The Cube View formats revert to default

Answer: (D)

When you refresh a sheet or workbook, the Cube View rebuilds from its data source using the predefined default formatting, so any temporary formatting changes you applied are not carried over. In other words, the formats revert to the defaults after a refresh. If you want specific formatting to persist, you need to save those settings with the Cube View (or reapply them after the refresh).