Hello all,
Excel is giving me some problems when I try to create a pivot table in workbook #1 that gets it data from workbook #2. Workbook #2 contains over 11 million cells with data in one sheet. I'm using Office 2010.
This is what happens with the raw data (top) and after import (bottom):
\1
I connect both workbooks through, Data, Connections, Add... and then add the workbook #2 containing the raw data. Everything connects fine but somehow the data that is imported in the background into the pivot in workbook #1 is changed, but not always! 1285,31 becomes 1,29E+16 and 80,00 becomes 80.
Does anyone have a solution to this problem?
Thank you in advance!
Bookmarks