How to assign a macro to a pivot in Excel 2000

D

DG

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
 
J

Jim Thomlinson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
How to set up a delay to Private Sub Worksheet_Change(ByVal TargetAs Range) event 6
Macro to refresh pivot chart - URGENT PLEASE !!!! T_T 3
Macro to Auto-refresh a pivot table 9
Macro to add data once a Pivot Table has been refreshed 1
OO4O and Pivot Table 3
How to reassign ODBC driver in using VBA macro 1
Programming a macro in Excel Office 2007 to create Pivot Table 1

Top