One way to test your theory is to take the data source & change them to
values instead of formulas. I've seen this occur when trying to aggregate
blank data.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"RedFive" wrote:

I have created a PivotTable using data in another spreadsheet. For some
reason when I try to sum the data in the Data Field, all the values turn to
zeros. But if I leave it as a count the information is correct. Is it
because the data in the original cells are formulas? Any help or
suggestions would be greatly appreciated. Thanks
--
RedFive