Is it possible to not let user Refresh Pivot tables unless a condition is satisfied?. Condition may be as simple as a cell containing a specific data.
Is it possible to not let user Refresh Pivot tables unless a condition is satisfied?. Condition may be as simple as a cell containing a specific data.
You could try something like this...
![]()
Please Login or Register to view this content.
HTH
Regards, Jeff
Thanks Jeff. I have like 10 pivot tables in a worksheet. However, I do not want the user to refresh it unless the data is generated in the source worksheet.
Is there way to do it for all the pivot tables or would it be efficient to put in a condition to active the pivot table worksheet only if a condition is met?
Thanks,
Booo
You could use something like this...
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks