Software

Ask something
Discussion Locked

Pivottable values change when exported

0 helpful
1 reply

by ccarroll

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

I exported a pivottable designed in Access 2003 to Excel and I noticed when checking the data in Excel that the values calculated for standard deviation changed! This only seems to have happened in one column and I can't find a reason for it.

Thanks for your help!

Camille

1 reply

by kowalczyk

I'd really like to know what to do. I have three column where the data changes from "SUM" to "COUNT" and I can't see the reason for it or the solution. One reason might be that these three columns were added after the table was made and used and calculated fields were added. thanks for your help! For both of us, because I think my problem is the same as Camille's.

Brigid

This discussion is closed to new replies.