Updates

2024	Analyze Tab, Drill Down removed
	Analyze Tab, Drill Up removed
2016	Time Grouping
	Suggested Relationships - Between two model tables
2013	Analyze Tab, Filter Group - "Sort Smallest to Largest" removed. Sorts the current selection so the smallest items are at the top. Still available for the Quick Access Toolbar.
	Analyze Tab, Filter Group - "Sort Largest to Smallest" removed. Sorts the current selection so the largest items are at the top. Still available for the Quick Access Toolbar.
	Analyze Tab, Filter Group - "Sort" removed. Displays the Sort by Value dialog box. Still available for the Quick Access Toolbar.
	The PivotChart - Layout Tab was removed.
	Options Tab was renamed to Analyze Tab
	Analyze Tab, Calculations Group - "Summarize Values By" removed. Drop-Down. The drop-down contained the commands: Sum, Count, Average, Max, Min, Product and More Options. In Excel 2010 this command appeared before the Fields, Items & Sets drop-down.
	Analyze Tab, Calculations Group - "Show Values As" removed. Drop-Down. The drop-down contained the commands: Show Values As - No Calculation, % of Grand Total, % of Column Total, % of Row Total, % Of, % of Parent Row Total, % of Parent Column Total, % of Parent Total, Difference From, % Difference From, Running Total In, % Running Total In, Rank Smallest to Largest, Rank Largest to Smallest, Index, More Options. In Excel 2010 this command appeared before the Fields, Items & Sets drop-down.
	Analyze Tab, Tools Group - "What-If Analysis" removed. Drop-Down. The drop-down contained the commands: Scenario Manager, Goal Seek and Data Table. This drop-down also appears on the Data Tab, Forecast group.
	Pivot Charts have been decoupled from Pivot tables
	New Drill Down and Drill Up functionality
	DataModel requires PowerPivot for Excel 2013 add-in
2010	Analyze Tab, Tools Group - "Formulas" removed. Drop-Down. The drop-down contains the commands: Calculated Field, Calculated Item, Solve Order, List Formulas.
2007	Pivot table limits increased - Instead of supporting 32,500 unique items per field they now support 1,048,576
	OLAP Cube Wizard removed
	VBA Version Property - The version property of a pivot table is completely separate from the version property of Excel. PivotTables in Excel 2007 will be version 12 (xlPivotTableVersion12). For example version 10 (xlPivotTableVersion) applied to Excel 2002 and Excel 2003. The version is determined by whether the user is working in compatibility mode.
	PivotTable Wizard removed
	SQL Server Analysis Services added
	Multi Threading added to speed up data retrieval, sorting and filtering.
	Fill Down Labels - labels can now be filled down
	Repeat Labels - you can also repeat labels to display item captions of nested fields in all rows and columns.
	Dynamic Sets - so when you work with the same set of items from data over and over again. The ability to easily create and reuse this logical grouping of items as a single object
	Show values as - includes several new automatic calculations such as % of parent row total, % of parent total.
	Named Sets - a tool that allows a re-usable group of items to be created for use in PivotTables
	PivotCharts added
	Compact Layout Option added