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...
Perhaps the worksheet is protected. Click on Tools, Protection and see if there is an Unprotect worksheet option available.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Yes it is protected.. but I do not know a way to hide the formulas without protecting the sheet.... If there is another way I would love to know it...
I may be approching the problem wrong I do not know.. but I need work sheet that will not show formulas but has full function...
Thank you
Sorry, I can't help any further. Perhaps someone more expert will come to your rescue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks