Pivot table not updating excel 2016

Rated 4.81/5 based on 825 customer reviews

Unfortunately, that article is retired, because the problem was solved in Excel 2000.

Well, it seems to be back, on my machine, at least.

You can download the sample file, and get the setup instructions, on my Contextures website: Data Validation Combo Box using Named Ranges Here is the retired MSKB article that I found in the Internet Archive: ________________ Article ID: 183503 Retired KB Content Disclaimer This article was previously published under Q183503 SYMPTOMS If you click the following items in a worksheet multiple times or if you move a vertical toolbar over a worksheet with any of the following items NOTE: Sometimes an action does not result in the message, but repeated actions do.

Worksheets("Sheet1") ' Dynamically Retrieve Range Address of Data Set start Point = data Sheet.

I have a Pivot table in excel that is using a raw table as its data source.

This pivot table is doing a bunch of grouping and summing of rows.

I'd like to now use the result of this new pivot table as the data source for a new pivot table which will further modify this data. I suppose you could call it 'nested pivot tables' In a new sheet (where you want to create a new pivot table) press the key combination (Alt D P). Display Alerts = True End Sub I guess your end goal is to show Distinct (unique) values inside your original Pivot table.

In the list of data source options choose "Microsoft Excel list of database". For example you could have data set with Order Number, Order Date, Order Item, order Qty First pivot table will show you Order Date and sum of Order Qty and you probably want to see Count of unique orders in the same Pivot.

Leave a Reply