| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh pivot table on protected sheet
Is there any way to allow a pivot table to refresh with a protected sheet? I
have the cells containing the pivot table "unprotected", but when the sheet is protected it still won't refresh. The "refresh data" option is grayed out. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refresh pivot table on protected sheet
On Jan 18, 10:46*am, richzip
wrote: Is there any way to allow a pivot table to refresh with a protected sheet? *I have the cells containing the pivot table "unprotected", but when the sheet is protected it still won't refresh. *The "refresh data" option is grayed out. When you protect your sheet, place a check mark next to "Use Pivot Table Reports" If your protecting the sheet in VBE or in a macro you would add , AllowUsingPivotTables:=True to the protection code. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refresh pivot table on protected sheet
No, you will have to unprotect the sheet, either manually or
programmatically, before you can refresh the pivot table. richzip wrote: Is there any way to allow a pivot table to refresh with a protected sheet? I have the cells containing the pivot table "unprotected", but when the sheet is protected it still won't refresh. The "refresh data" option is grayed out. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refresh pivot table on protected sheet
On Jan 18, 2:01*pm, Debra Dalgleish wrote:
No, you will have to unprotect the sheet, either manually or programmatically, before you can refresh the pivot table. richzip wrote: Is there any way to allow a pivot table to refresh with a protected sheet? *I have the cells containing the pivot table "unprotected", but when the sheet is protected it still won't refresh. *The "refresh data" option is grayed out. -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html Sorry about that Debra is right. It wont refresh unless the sheet is unprotected. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| Pivot Table Refresh Deletes Range On Different Sheet | Excel Discussion (Misc queries) | |||
| Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
| How do you unlock a pivot table on a protected excel sheet? | Excel Worksheet Functions | |||
| Pivot Table Use When Sheet is Protected | Excel Discussion (Misc queries) | |||
Linear Mode
