Pivot Table Calculation Error

L

lawman

I have a pivot table that is pulling from another worksheet. When I manully
calculate the same it comes out with 88,628 (this is from summing 3 fields
together.) In the pivot table, some of the sum calculations are correct
while others aren't. The value I am getting for the above mentioned manually
calculation is 91,314. When I look at it line by line, 2 of lines are
incorrect and 1 is correct. Any ideas? This is in Excel 2007.
 
N

Nick Hodge

Check all the source cells are in fact numbers and not text *looking* like
numbers. (Take of any alignment formatting and if it right aligns naturally
it's a number, if it aligns left it's text

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2nd Pivot Table on Worksheet Crahes Excel 1
pivot table error:Too many records to complete this operation 3
Access #Error & Excel Pivot 0
Pivot Table Error in 2007 - missing data when refreshed 1
Pivot Table #Div/0! 2
Error with using Max in a Pivot Table 1
Pivot table insertion changes upper and lower case letters 3
Playing back a Pivot Table macros 2

Top