Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to assign a macro to a pivot in Excel 2000
Hi everyone.
The problem concerns Excel 2000. There is a pivot and a macro in the worksheet. This macro should run automatically each time a new pivot table report is displayed or pivot data are refreshed. I couldn't assign a macro to pivot dropdown menu. Private Sub Worksheet_PivotTableUpdate() event is neither accessible (Excel 2000). I tried searching Google for any hint of a problem but couldn't find any. Could you please give me some clues? Regards, DG |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to assign a macro to a pivot in Excel 2000
The pivot table engine was changed in XL2002. Code is not backwards
compatible between 2000 and XP. In 2000 and prior you only have the calculation event to rely on. It is kind of hokey but you can make it work... -- HTH... Jim Thomlinson "DG" wrote: Hi everyone. The problem concerns Excel 2000. There is a pivot and a macro in the worksheet. This macro should run automatically each time a new pivot table report is displayed or pivot data are refreshed. I couldn't assign a macro to pivot dropdown menu. Private Sub Worksheet_PivotTableUpdate() event is neither accessible (Excel 2000). I tried searching Google for any hint of a problem but couldn't find any. Could you please give me some clues? Regards, DG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do) | Excel Programming | |||
Assign a macro to create a pivot table | Excel Programming | |||
I cannot use Assign macro in Excel. Could before but not now. A. | Excel Programming | |||
Create macro to download access 2000 table to excel 2000 spreadsheet | Excel Programming | |||
Is it possible to assign a macro to a pivot table? | Excel Programming |