I am using excel 2000.. I need to have a work sheet protected... but a need a pivot table to be refreshed on a regular basis.... Even though the cells that the pivot table would update are not locked, I get the message that the pivot tabel cannot update on a protected sheet..

Maybe I am going about this wrong.... All I really need is to hide all formulas but have all other functions available...


Please help!!!

Thank you...