Pivot Table Refresh option not able to see

[Prashanth KR]

Hi,

I have a workbook where sheet1 contains data having various columns. Sheet2
contains the pivot table from the sheet1.

Iam able to refresh the data in the Pivot table for the first time, but
one's Iam done and open the workbook the next day, I do not see the refresh
option by right clicking the pivot table.

Please note Iam using 2003, also the sheet1 is protected while the sheet2
which has the pivot table is unprotected.

I want to make the sheet1 protected as it is used by many people.

Your timely help will be highly appreciated.

Thanks,
Prashanth KR.

 

[Roger Govier]

Hi

Having the source data on a protected sheet is fine, as long as the sheet
with the PT is unprotected, and provided that a copy of the PT does not
exist on a protected sheet.