Hi Folks,

I am a .NET programmer but have very little VBA experience. I have
created a crosstab report based on a pivot table. What I should like
to do is to get the underlying data from the cells in the pivot table.
When I double-click on a cell in the pivot table a new worksheet is
opened with the corresponding data displayed. However, I wanted to ask
whether there is a way to get at the underlying data for each cell in
the pivot table?

I'm sure there must be but I just can't work out from the
documentation what I need to.

Many thanks in advance!

David