Solved

Pivot help

Posted on 2016-11-14
3
34 Views
Last Modified: 2016-11-14
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
Comment
Question by:pdvsa
3 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41886176
Hi,

right click your pivot and refresh

Regards
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41886248
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
 

Author Closing Comment

by:pdvsa
ID: 41886282
thank you.  That is odd that excel wouldnt refresh.  

thank you Martin for the activate suggestion.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now