Lock the Pivot Table but still can refresh

You can't. The pivot table can only refresh when the sheet is unprotected.

You can use VBA that runs when the sheet is activated. Record a macro to

- unprotect the sheet
- refresh the pivot table
- protect the sheet

Then put that code into the Worksheet_Activate event.