I have created a pivot chart and then saved it as a Form. i then created a command button which is to open this form to view the pivot. So the user open the pivot when he click this button. Now the user can drag/drop some fields... like they drag out a row field. he exit. when he re-presses the cmd button, the row field is out.
how do i get the original format? how can i make sure when the user click the cmd button, the original pivot is preserved? I dont mind they change the rows but when they re-open the pivot i want it to be the same it was before not with their changes.
I am using a multi user database. so i dont want user x to change the pivot of user y.
how do i get the original format? how can i make sure when the user click the cmd button, the original pivot is preserved? I dont mind they change the rows but when they re-open the pivot i want it to be the same it was before not with their changes.
I am using a multi user database. so i dont want user x to change the pivot of user y.
