Hello Forum users,

Does anyone know how to get a pivot table to refresh even when a worksheet is protected? The option is greyed out even though the cells in the pivot section are unlocked and I have allowed users to select unlocked cells.

Paula