Add-ins by Release
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. |
| Power View - This add-in was removed and replaced with Power BI Desktop which is a standalone application. |
| Power Map - This add-in was removed because the functionality is now built-in. |
| Inquire - This add-in was removed. |
| 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. |
| Power View - This add-in was removed and replaced with Power BI Desktop which is a standalone application. |
| Power Map - This add-in was removed because the functionality is now built-in. |
| Inquire - This add-in was removed. |
2013
| Fuzzy Lookup - This add-in can be downloaded from the Microsoft website and allows you to compare two tables and perform matching analysis. |
| Fuzzy Lookup - This add-in can be downloaded from the Microsoft website and allows you to compare two tables and perform matching analysis. |
2010
| Power Pivot - This add-in was first available for downloaded from the Microsoft website. |
| 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. This add-in was called the Internet Assistant Wizard in Excel 97 with the file name html.xla You can convert data in cells directly to HTML either a separate web file or into an existing web file. |
| 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. There were three add-ins which you can download for Office 2007 that will enable you to save files direct to PDF and also to XPS format. XML Paper Specification (XPS) XPS is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The XPS format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed. |
| Interactive Ribbon Guide 2010 - A visual, interactive reference guide to help you find commands in Excel 2010. |
| Smart Tags were deprecated. |
| Power Pivot - This add-in was first available for downloaded from the Microsoft website. |
| 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. This add-in was called the Internet Assistant Wizard in Excel 97 with the file name html.xla You can convert data in cells directly to HTML either a separate web file or into an existing web file. |
| 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. There were three add-ins which you can download for Office 2007 that will enable you to save files direct to PDF and also to XPS format. XML Paper Specification (XPS) XPS is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The XPS format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed. |
| Interactive Ribbon Guide 2010 - A visual, interactive reference guide to help you find commands in Excel 2010. |
| Smart Tags were deprecated. |
2007
| Delete Links Wizard This add-in (DelLinks.xla) was removed in 2007 and could be used to delete links to external files in one or more workbooks. The only way to perform this task is to manually delete the links or to use a Microsoft Visual Basic for Applications macro to search, find, and delete the links. |
| Remove Hidden Data This add-in was removed and could remove meta data from Excel that you don't want other people to see. It was replaced with the 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). |
| Delete Links Wizard This add-in (DelLinks.xla) was removed in 2007 and could be used to delete links to external files in one or more workbooks. The only way to perform this task is to manually delete the links or to use a Microsoft Visual Basic for Applications macro to search, find, and delete the links. |
| Remove Hidden Data This add-in was removed and could remove meta data from Excel that you don't want other people to see. It was replaced with the 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). |
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. This was always an additional add-in that could be downloaded and installed and was never made available by default. Excel 2016 introduced Linked Data Types - Stock |
| 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). |
| 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. This was always an additional add-in that could be downloaded and installed and was never made available by default. Excel 2016 introduced Linked Data Types - Stock |
| 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). |
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 (xlquery.xla) was removed. |
| ODBC This add-in (XLODBC.xla) was removed. This is short for Open Database Connectivity and allows you to connect to external data sources using ODBC drivers. This add-in also provided the additional SQL.REQUEST worksheet function. This was replaced with ActiveX Data Objects. |
| 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. When you used this add-in a number of named ranges were automatically created and they were all prefixed with "wrn." |
| Template Utilities This add-in (Tmpltnum.xla) 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 (wztemplt.xla) was removed. This helps you to create worksheet templates. This allowed you to set up a simple Excel-based front end to a central database. Using a data entry form within a worksheet, users can add new records to the database and update existing records. |
| Update Links This add-in (Updtlink.xla) 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. |
| 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 (xlquery.xla) was removed. |
| ODBC This add-in (XLODBC.xla) was removed. This is short for Open Database Connectivity and allows you to connect to external data sources using ODBC drivers. This add-in also provided the additional SQL.REQUEST worksheet function. This was replaced with ActiveX Data Objects. |
| 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. When you used this add-in a number of named ranges were automatically created and they were all prefixed with "wrn." |
| Template Utilities This add-in (Tmpltnum.xla) 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 (wztemplt.xla) was removed. This helps you to create worksheet templates. This allowed you to set up a simple Excel-based front end to a central database. Using a data entry form within a worksheet, users can add new records to the database and update existing records. |
| Update Links This add-in (Updtlink.xla) 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. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext