Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 55
  • 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 LissRetired ProgrammerCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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