Excel 2007 : pivot table options and refresh question

[jmccullough]

I have a pivot table that I want the users to be able to use the dropdowns to filter their data. I also want to protect the worksheet to prevent "accidental" deletion of data so I have checked the "allow users to use pivot table reports". This works fine but now I need to "refresh" the protected pivot table when different users want to view their data. I have inserted the following piece of code to refresh the pivot table and it works correctly but it also "unchecks" the option to allow the use of the pivot table reports!!! So it refreshes the pivot table but I lose the option for the users to filter the data. Is there a line of code I could insert so that the checkbox gets rechecked?

Here is the code I'm using to refresh my pivot table:

Please Login or Register  to view this content.

Thank you for any assistance.