Pivot Table - Sub totals

Discussion in 'Computer Support' started by yazh, Sep 22, 2005.

  1. yazh

    yazh Guest

    Hi all,
    I have one issue when i get the data through the pivot table
    option. after creating a pivot table, i enabled the sub-total and the
    grand total in the pivot table properties. after enabling that the
    sub-total and the grand total columns appear as #VALUE!.

    I have office 2003 in OS 2000 proffesion.

    Please help me

    yazh, Sep 22, 2005
    1. Advertisements

  2. yazh

    MJP Guest

    Make the column wider?
    MJP, Sep 22, 2005
    1. Advertisements

  3. yazh

    why? Guest

    That will be Excel 2003, as Office 2003 contains several different apps.
    Try the Excel Help -

    Open Excel and press F1, (if it's any thing like Excel 2000) in the
    Index tab the first few entries start with #.

    In the list, if you scroll down is an entry for #VALUE! , double click
    the entry. I get 6 topics to select , things like -

    Troubleshoot formulas and error values
    What does the error #VALUE! mean?
    why?, Sep 22, 2005
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.