Forum Discussion

Krjac's avatar
Krjac
New Contributor
11 months ago

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!

Excel Add In
  • db_pdx's avatar
    db_pdx
    11 months ago

    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.

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    11 months ago

    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.