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,
