Follow via:
RSS
Email Alert
Question
0 Votes
+ -

Pivottable values change when exported

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
Tags: software
19th May 2005

Answers (1)

0 Votes
+ -
I have the same problem
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
8th Dec 2009
Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.