| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot Refresh Pivot Tables
I have 2 worksheets.
One has several Pivot Tables that need to be refresh (but I want to Protect this worksheet) The other worksheets has a command button with a macro associated with it to refresh my Pivot Tables. My problem is that once I have Protected the worksheet with the Pivot Tables the Command Button results in a Run-time error '1004': Cannot edit PivotTable on protected sheet. Is there a solution to this problem - short of just Format Sheet Hide? -- Babs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables Refresh | Excel Discussion (Misc queries) | |||
| Refresh multiple pivot tables | Excel Discussion (Misc queries) | |||
| Pivot Tables -- Auto Refresh | Excel Discussion (Misc queries) | |||
| Refresh all pivot tables in a workbook | Excel Discussion (Misc queries) | |||
| refresh pivot tables through a macro | Excel Worksheet Functions | |||
Threaded Mode
