Thanks for reply. Within pivot table have dozens of "calculated fields" or
formula which on the 2000 version can be seen by right clicking anywhere on
pivot selecting "formula" and then "list formula" - result a worksheet with
all the created formula listed.

Can't see any way of performing on 2003 version.

If know of one would appreciate it.

Regards,

jpjejmcc

"David McRitchie" wrote:

Please help yourself by including the question in the body, even
if it is word for word the same as in the subject line. I think
you could have elaborated a bit more in the body anyway.

I don't know of anyway to show what the actual formula for a cell
in a Pivot Table is. Why is that important to you. I kind of
thought it obvious what a cell is comprised of.

Anyway a Pivot table is a builtin generated report.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jpjejmcc" wrote in message ...