Hi,

I know the use of pivot tables in protected sheets has been discussed a lot, but they always seem to revert to using Macros to unprotect, refresh, then reprotect the sheet.
This is not feasible for me as the people who will be using the file cannot be trusted to run the macro on the correct sheet (i.e. not impact on other sheet).
Additionally, i cannot store the pivot table on a different (unprotected) sheet due to the sheer number of projects that will come on line / close over the lifetime of the file.

Basically, exluding the use of Macros or background sheets. Is there any way to refresh a Pivot table on a sheet that is protected?
(i've tried keeping cells in the area of the pivot table unlocked)

Louise