Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jpjejmcc
 
Posts: n/a
Default Excel 2003 view formula within pivot table


  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

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 ...



  #3   Report Post  
jpjejmcc
 
Posts: n/a
Default

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 ...




  #4   Report Post  
David McRitchie
 
Posts: n/a
Default

I have Excel 2000 and I don't find any formulas in my
Pivot Table report -- My P.T. would be only comprised of
additions (SUM).

Specifically I switched to formula view to be sure I didn't miss
anything.

Possibly you used to reformat the output pivot table with
formulas in some manner.
---
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 ...
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 ...







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking parameter query from Access to pivot table in Excel ken1975 Excel Discussion (Misc queries) 2 June 20th 06 01:51 PM
Excel Pivot Table with Access ExcelQuestions Excel Discussion (Misc queries) 0 April 11th 05 03:37 PM
Excel XP Pivot Table in Excel 2000 bsantona Excel Discussion (Misc queries) 0 January 20th 05 07:37 PM
Adding a formula to a pivot table Tony Excel Discussion (Misc queries) 2 January 20th 05 11:27 AM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 07:45 PM


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"