Hello everybody,

I have an Excel 2010 file with 3 protected sheets, where each sheet contains 2 pivot tables (total 6 pivot tables).
I need one or more macro to refresh all the 6 pivot tables in the 3 protected sheets. Also, I need to know where to place the VBA code(s).
I found many useful macros posted by Dave in this forum but I didn't succeed to let them refresh all the pivot tables at once (may be because I placed the code in the wrong place). Please advise also if I have to insert "Option Explicit" before the VBA code.

Many thanks in advance for your kind help!!
EF