pivotcell object for excel 2000

[Kellyc]

Hi every body,
I have the macro code and It allow to do drillthrough in a pivottable (cube
of analysis services)in excel..the macro work very fine in excel xp but I
need it in excel 2000 but when i execute it in excel 2000, here ocurr a
definition error because of the pivotcell object...I was investigating in
intenet and i find that pivotcell object isn't available in excel 2000.

¡¡¡I need to know How can I install pivotcell object in excel 2000 and so I
can use the macro????

Please Do I need to intall some component???

thanks.

 

[Bob Buckland ?:-\)]

Hi Kelly,

Not all features of newer versions are going to
be available in older versions of a product but
you may want to also post this in the MS Excel groups
(link below) to see what options/workarounds may be
available.

==========
Hi every body,
I have the macro code and It allow to do drillthrough in a pivottable (cube
of analysis services)in excel..the macro work very fine in excel xp but I
need it in excel 2000 but when i execute it in excel 2000, here ocurr a
definition error because of the pivotcell object...I was investigating in
intenet and i find that pivotcell object isn't available in excel 2000.

¡¡¡I need to know How can I install pivotcell object in excel 2000 and so I
can use the macro????

Please Do I need to intall some component???

thanks.>>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com