Skip to main content
Newcomer
Jan 17, 2024 3:29 PM UTC
Solved

Keeping Excel formulas when refreshing Quick view with new PoV

When refreshing a quick view after having changed the PoV, any formula in the row that is refreshed will be cleared.
Is it possible to retain the formula ?

Example:

A1 Formula B1 PoV C1 PoV

When changing B1 and C1, and refreshing A1 will be cleared.

Thanks!

db_pdxAnswer
Contributor
Jan 17, 2024 4:36 PM UTC

In the Quick View settings, at the top are two settings: "Insert or Delete Rows (Columns) When Resizing Cube View content".  Try turning both to False and see if that fixes your issue.

2 replies

db_pdxAnswer
Contributor
Jan 17, 2024 4:36 PM UTC

In the Quick View settings, at the top are two settings: "Insert or Delete Rows (Columns) When Resizing Cube View content".  Try turning both to False and see if that fixes your issue.

KrjacAuthor
Newcomer
Jan 18, 2024 7:53 AM UTC

Thanks this seems to work!