+ Reply to Thread
Results 1 to 7 of 7

Excel 2003 view formula within pivot table

  1. #1
    David McRitchie
    Guest

    Re: Excel 2003 view formula within pivot table

    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" <jpjejmcc@discussions.microsoft.com> wrote in message news:0D240251-42C4-4DCB-8C01-EB6E83080711@microsoft.com...
    >




  2. #2
    jpjejmcc
    Guest

    Re: Excel 2003 view formula within pivot table

    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" <jpjejmcc@discussions.microsoft.com> wrote in message news:0D240251-42C4-4DCB-8C01-EB6E83080711@microsoft.com...
    > >

    >
    >
    >


  3. #3
    David McRitchie
    Guest

    Re: Excel 2003 view formula within pivot table

    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" <jpjejmcc@discussions.microsoft.com> wrote in message news:F8F97B67-198C-40F1-8103-8C2D3AC8C199@microsoft.com...
    > 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" <jpjejmcc@discussions.microsoft.com> wrote in message news:0D240251-42C4-4DCB-8C01-EB6E83080711@microsoft.com...
    > > >

    > >
    > >
    > >





  4. #4
    jpjejmcc
    Guest

    Excel 2003 view formula within pivot table



  5. #5
    David McRitchie
    Guest

    Re: Excel 2003 view formula within pivot table

    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" <jpjejmcc@discussions.microsoft.com> wrote in message news:0D240251-42C4-4DCB-8C01-EB6E83080711@microsoft.com...
    >




  6. #6
    jpjejmcc
    Guest

    Re: Excel 2003 view formula within pivot table

    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" <jpjejmcc@discussions.microsoft.com> wrote in message news:0D240251-42C4-4DCB-8C01-EB6E83080711@microsoft.com...
    > >

    >
    >
    >


  7. #7
    David McRitchie
    Guest

    Re: Excel 2003 view formula within pivot table

    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" <jpjejmcc@discussions.microsoft.com> wrote in message news:F8F97B67-198C-40F1-8103-8C2D3AC8C199@microsoft.com...
    > 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" <jpjejmcc@discussions.microsoft.com> wrote in message news:0D240251-42C4-4DCB-8C01-EB6E83080711@microsoft.com...
    > > >

    > >
    > >
    > >





+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06373 seconds
  • Memory Usage 8,971KB
  • Queries Executed 16 (?)
More Information
Template Usage (30):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (7)postbit_legacy
  • (7)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (40):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php
  • ./includes/functions_prefix.php 

Hooks Called (44):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1