Skip to main content
K
Krjac
January 17, 2024
Solved

Keeping Excel formulas when refreshing Quick view with new PoV

  • January 17, 2024
  • 2 replies
  • 0 views

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!

Best answer by db_pdx

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

D
db_pdxAnswer
January 17, 2024

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.

K
KrjacAuthor
January 18, 2024

Thanks this seems to work!

Terms & ConditionsAccessibility statement