data discrepancy in Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two pivot tables feed off from the same Access query. One is in Excel
workbook, another is in data access page. There is some data discrepancy
exists between them. How come? I really run out of idea what could cause the
problem.
Can someone please help me here?

Thanks a lot in advance!
 
If they were my pivot tables, I would drill down to find where they are
showing discrepancies.
 
Thanks for your rapid reponse. THere is some more information about the
problem: I exported from data access page to excel and data matchs the pivot
table sits in the original Excel workbook. So why the information displayed
in data access page is different from Excel? I know what data is diffeent but
I don't know why it is different even I choose all same filters.

Thanks for your help!
 
I don't know if any of us have experienced the same issue. Again, I would
suggest you drill down and look at the "raw" records to find any clues.
 
Back
Top