Debra Dalgleish wrote:
The example link you posted is not for Excel 2000 -- it's for Excel 2002
or later versions.
In Excel 2000, use the item names within one set of quote marks. For
example, if the pivot table starts in cell B13:

=GETPIVOTDATA($B$13,"Apr Richard")

OK. This works with one minor change. I need to replcae the `,` with a
`;` Otherwise perfect. May thanks (and now on to management to ask them
to please update Excel)

Now I can go and re-write all the excel files, making it a LOT easier
for me to get my weekly statistics out. I already went down from some 16
hours to 4. Now I should be ready in 2. Mmm. Should I tell that to
management or not. :-D

Thanks again. This will also (partly) solve the other issues I had with
Pivot tables.

houghi
--
Remind me to write an article on the compulsive reading of news. The
theme will be that most neuroses can be traced to the unhealthy habit
of wallowing in the troubles of five billion strangers. -- Heinlein