Is there a way to have a worksheet protected, but still allow selections on a pivot table? Thanks.
S shawn modersohn Jan 25, 2004 #1 Is there a way to have a worksheet protected, but still allow selections on a pivot table? Thanks.
P Peo Sjoblom Jan 25, 2004 #2 It depends on the version, if you have 2003 (maybe 2002 as well?) you can select use pivot table reports when you protect the sheet. Of course the drawback is if you send it to anyone with 97 or 2000 they can't use it. -- Regards, Peo Sjoblom
It depends on the version, if you have 2003 (maybe 2002 as well?) you can select use pivot table reports when you protect the sheet. Of course the drawback is if you send it to anyone with 97 or 2000 they can't use it. -- Regards, Peo Sjoblom
