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 update pivot table data range 3
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 13
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and P 0
Corrupt files due to pivot remnants after saving via VBA 0
Macro Help in Pivot 2
How to set up a delay to Private Sub Worksheet_Change(ByVal TargetAs Range) event 6
Pivot Table Macro, exclude possible blanks 0
Macro to refresh pivot chart - URGENT PLEASE !!!! T_T 3

Top