I am adding data on the fly to pivot table when realtime data is pushed to my webapp. But whenver I call refresh after adding data, the pivot table loses the collapsed/expanded pivots. I want to somehow add the data silently without the user required to navigate to the section he/she was looking at it by going through all the expansion/collapse again.
Thanks,
Vivek.