How to assign a macro to a pivot in Excel 2000

's Computer Specifications

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

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 -- Assign a macro to a button	Steve	Microsoft Excel Misc	1	27th Oct 2009 03:45 PM
Assign a macro to create a pivot table	acsugguiyao	Microsoft Excel Programming	2	23rd Jun 2005 03:04 AM
I cannot use Assign macro in Excel. Could before but not now. A.	=?Utf-8?B?T1dVIFByb2dyYW1taW5n?=	Microsoft Excel Programming	4	10th Dec 2004 10:29 PM
Why won't Excel allow me to assign a macro to run from a command .	=?Utf-8?B?bHRpbmRhMDE=?=	Microsoft Excel Misc	3	21st Oct 2004 05:47 PM
Is it possible to assign a macro to a pivot table?	James Sherman	Microsoft Excel Programming	0	22nd Jul 2003 12:24 AM