Pivot Table not updating even after refresh :(

Hello,

Like the title says, pivot table is not updating . Yes, I know... I already checked the source data, and hit pivot table refresh, but it doesn't update.

The excel is hooked up with mysql database, using ODBC connection. I am pulling in raw data into a table, and then into a Pivot Table that is based of that table (for reasons, I am not pulling raw data directly into Pivot Table). Now, when I hit refresh, it pulls in the raw data, but even when I hit Pivot Table refresh, it does not give me correct numbers. Funny thing is, if I click at a number in pivot table, and it gives me the detail behind that number, that is correct. For example, real number should be 80K... but Pivot Table is showing 30K. Now, if I double click on that 30K, opening up another sheet that gives the numbers behind that 30K, the sum of those numbers is 80K.... but how come it is not showing 80K in the Pivot Table .

Have been trying everything... created another Pivot Table of the same data, and it was fine (but I dont want to do it again and again.. its for different users)....

Anyone has any idea whats going on? Will really appreciate any help.

Thanks .

Sorted out the problem guys.... .
Thanks..