Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2008
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data sum = zero in a pivot table (excel 2000)

    I have created two pivot table in two different files, both are basically the same, i have done nothing different.

    On both i need to display the sum of as picked from right click drop down menu. On the first it worked on the second it is giving a zero value. The original setting was count of and this gave a value.

    I am guessing it is something really simple and probably somewhere in the archive but i can't find it.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: data sum = zero in a pivot table (excel 2000)

    Perhaps the data values in the second file are stored as text even though they look like numbers.

    First, select the source data and make sure that the cells have not been formatted as Text in the Number tab of Format | Cells...
    Next, select an empty cell and copy it to the clipboard.
    Select the source data, then select Edit | Paste Special...
    Select the Add option, then click OK.
    Now click somewhere in the pivot table and click Refresh on the Pivot Table toolbar.

    Does that help?

  3. #3
    New Lounger
    Join Date
    May 2008
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data sum = zero in a pivot table (excel 2000)

    Thanks, i found the problem, for some reason every number is preceded with an apostrophe? So there are items to count but no numbers to sum.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: data sum = zero in a pivot table (excel 2000)

    Values prefixed with an apostrophe are interpreted as text. The Copy a blank cell > Paste Special with the Add option that I described in my previous reply should fix that.

Posting Permissions

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