Hi John

Add the following code to the worksheet

Private Sub Worksheet_Activate()
ActiveSheet.Unprotect
PivotTables(1).PivotCache.Refresh
ActiveSheet.Protect
End Sub

Copy the Code above
Right click Sheet tab View Code
Paste code into white pane that appears
Alt+F11 to return to Excel

This is event code which will be triggered automatically.
--
Regards
Roger Govier

"johnsail" wrote in message
...
Is it possible to automatically update (refresh data) a pivot table from a
protected sheet as data is entered?

The sheet with the pivot table needs to be protected/hidden.

John