• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 62
  • Last Modified:

Pivot help

experts,

I am trying to PIvot a large data set.
I do not know why when I drag [WCDraw] into the pivot, it shows 0 for a sum.  
I thought it was because the format was text and I converted it using text to columns but it still shows 0.  

Any thoughts?
Please see attached.

thank you

screenshotqryImport_FC_Archive_4Pivot.xlsx
0
pdvsa
Asked:
pdvsa
1 Solution
 
Rgonzo1971Commented:
Hi,

right click your pivot and refresh

Regards
0
 
Martin LissOlder than dirtCommented:
If you put this in the Worksheet_Activate code for the sheet that contains the pivot table it will be automatically refreshed every time you go to the sheet. You will of course then have to save the workbook as an xlsm file.

PivotTables("PivotTable1").PivotCache.Refresh
0
 
pdvsaProject financeAuthor Commented:
thank you.  That is odd that excel wouldnt refresh.  

thank you Martin for the activate suggestion.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now