Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Error in pivot table (XP)

    I have this big spreadsheet from work. The pivot table gives a different total then the spreadsheet. Which I find odd.
    I am now checking all the formulas in the worksheet.
    Is there a quick way of checking if there are any hidden amounts or so ?? I have done a F5 to have the blanks show, but it only shows about 50% of the blanks which isn't very helpful.

    Any help is appreciated

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

    Re: Error in pivot table (XP)

    You may be able to use the Trace Precedents feature from the Formula Auditing toolbar.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error in pivot table (XP)

    Just checking, but have you refreshed the pivot table? Also, try pressing Ctrl-Alt-F9 to force a global recalculation on the sheets in Excel.
    Regards,
    Rudi

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Error in pivot table (XP)

    I have tried to F9 the pivot table.
    2 columns are fine, the other 6 have a difference.
    There are about 900 rows in which perhaps 200 sums... so tracing is a never ending job
    Thanks anyway

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error in pivot table (XP)

    I'm not too sure how large the pivot table is, but if the source of the error cannot be found and all else fails....attempt to reconstruct a new pivot of the source data and see if that does not resolve the issue!
    Cheers
    Regards,
    Rudi

Posting Permissions

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