Excel 365 | Power Map - A 3D data visualization tool for creating maps. |
Excel 2021 | no changes |
Excel 2019 | no changes |
Excel 2016 | Power Query - This add-in was removed because this functionality is now built-in and can be accessed from the Get & Transform group on the Data tab. |
| Inquire - This add-in was removed. |
Excel 2013 | Power View - This add-in was removed and replaced with the Power BI Desktop. |
| Fuzzy Lookup - Allows you to compare two tables and perform matching analysis. |
Excel 2010 | Conditional Sum Wizard - This add-in was removed and replaced with a SUMIFs worksheet function. |
| Get Started Tab - This add-in was removed. |
| Community Help Tab - This add-in was removed. |
| Internet Assistant VBA - This add-in was removed because there are other ways to publish data to the web. |
| Lookup Wizard - This add-in was removed so cross referencing formulas will have to be entered manually. |
| Save As PDF - This add-in was removed because this functionality is built-in. |
| Save As PDF or XPS - This add-in was removed. |
| Interactive Ribbon Guide 2010 - A visual, interactive reference guide to help you find commands in Excel 2010. |
Excel 2007 | Delete Links Wizard - This add-in was removed. |
| Remove Hidden Data was removed and has been replaced with the new Document Inspector functionality. |
| Analysis-ToolPak - The worksheet functions are now standard worksheet functions and are available without having to install the Analysis-ToolPak add-in. |
| Interactive Ribbon Guide 2007 - A visual, interactive reference guide to help you find your 2003 commands in 2007. |
| Excel Viewer - Lets you view workbooks created in Excel 97 and later versions (2007). |
Excel 2003 | Access Links - This add-in was removed. For use with Microsoft Access, creates forms and reports linked to data in Excel. Requires Microsoft Access to be installed on your PC. |
| XML Tools - This creates an XML data file and XML schema file from a range of cells. |
| MSN Money Stock Quotes - This add-in was removed. This allowed you to import stock quotes from MSN Money and Yahoo Finance. |
| Euro Currency Tools Smart Tag - This smart tag was removed. |
| Compatibility Pack - Allows users of Excel 2003 to open files in the new open xml file format (2007). |
Excel 2002 | AutoSave - This add-in was removed. This will allow your workbooks to be saved automatically after a certain period of time. There are options as to whether to save all open workbooks or just the active workbook. If you find the prompting annoying it can be removed by pressing (Tools > AutoSave, "Prompt before saving"). |
| File Conversion Wizard - This add-in was removed. This creates formula that sums only the items in a list that meets a specific criteria. |
| Integration Bookshelf - This add-in was removed. This supports a lookup and copy facilities to Excel from Microsoft Bookshelf application. |
| Microsoft Query - This add-in was removed. |
| ODBC - This add-in was removed. This is short for Open Database Connectivity and allows you to connect to external data sources using ODBC drivers. |
| Report Manager - This add-in was removed. This lets you define a number of reports that can contain various print ranges from within your workbook, different custom views and scenarios. |
| Template Utilities - This add-in was removed. This provides utilities used by spreadsheet solutions templates. This is loaded automatically when you use one of these templates. |
| Template Wizard with Data Tracking - This add-in was removed. This helps you to create worksheet templates. When this add-in is installed an additional "Template Wizard" command appears on the (Data) drop-down menu. |
| Update Links - This add-in was removed. |
| Web Form Wizard - This add-in was removed. This takes you through creating an HTML table from a range in an Excel spreadsheet. |