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.