0 Replies Latest reply: Apr 2, 2012 1:52 PM by Sean Smith RSS

    Sheet Objects Recalculating

      Quick Q,

      I have a sheet object with a pivot table and the expressions are built using set analysis.  When I am designing, if I move a different object on the sheet, say reposition a list box or resize it, my chart will recalculate the data as if I had selected a new selection.  I was curious if this is expected or ?  Can it be prevented?  It can be a bit of a pain having to wait all the time.   Thanks,