How To Enable Automatic Update Of Links In Excel 2016

Ability Query is an amazing data tool for Excel! It is built by Microsoft to help you lot import, transform, and automate your data processes. Checkout my overview of Power Query to learn more about it.

Hither is a quick list of compatible versions:

"Complimentary" add-in for Excel 2010 and 2013 for Windows.
Built-in feature for Excel 2016 for Windows (Role 365 Subscription). Click here to learn where to find it.
Ability Query is not nonetheless bachelor for the Mac versions of Excel.

Complete Guide to Installing Power Query

This page will help you determine if you accept the right version of Excel, and provide installation instructions.

Video Guide to Installing Ability Query

What Version Do I Need?

The download page for Ability Query lists which version of Excel are compatible with Power Query.

The following Office versions for Windows are supported:

Microsoft Office 2016 – All Versions
Microsoft Office 2013 – All Versions
Microsoft Function 2010 Professional Plus with Software Assurance

Both 32-bit and 64-bit are supported. Ability Query is not uniform with any Mac versions of Excel yet.

Unfortunately, if you lot don't take these versions you will demand to upgrade to use Power Query. To me, Power Query is worth the upgrade to Office 365 alone, and at that place are a lot of other cool new features also.

How Do I Check My Version of Excel?

Excel 2010

Hither's how to decide your version and 32 or 64 flake in Excel 2010:

Click the File button.
Click the Assistance option on the left side menu.
The Excel version will be listed under the Product Activated section.
The bit version (32-bit or 64-bit) will be listed nether the About Microsoft Excel section.

Excel 2010 Version and 32 or 64 bit

If your Excel looks like the screenshot above, and then you are in luck! 🙂 Again, you lot will need the Professional Plus version of Excel 2010.

Excel 2013

Here'south how to determine your version and 32 or 64 bit in Excel 2013:

Click the File button.
Click the Business relationship option on the left side card.
The Excel version will be listed under the Subscription Production section.
Click the About Excel push button. The flake version (32-scrap or 64-fleck) will be listed in the first row of the popular-upwards window.

Excel 2013 Version and 32 or 64 bit

How to Install Power Query

Excel 2016

Power Query is included with Excel 2016 (Office 365). It has been renamed and is at present on the Data tab of the Ribbon in the Become & Transform section.

Power Query in Excel 2016 for Windows Data Tab of Ribbon Get and Transform

This means at that place is nil to install. If you are using Excel 2016, go to the Data tab on the ribbon and printing the New Query button to create a query and open the Power Query editor.

Power Query is available with all levels of Function 365 subscriptions. Here is an article that explains the features available for each subscription level.

Information technology's of import to note that in that location are some differences in Ability Query for unlike builds of Excel 2016.

If you are on the MSI (Windows Installer) version then yous will not go frequent updates to Power Query. Your ribbon might await dissimilar from mine, and you won't have all the latest features.

If you are on an Office 365 subscription then y'all accept the Click-to-run version and y'all should get all the latest updates. Here is an commodity on how to determine which version of 2016 your are on.

If you lot are on the ProPlus version of Part 365 and then you lot might be on the Deferred Aqueduct. The proper name of the Deferred Aqueduct has been inverse to Semi-Annual Channel as of September 2017. This means you get updates every six months instead of every month.

Here is an article about the different channels for Function 365 ProPlus.

Here is an article on how to switch channels.

All the versions and channels make this very confusing, to say the to the lowest degree. Hopefully this guide helps you effigy out how to get Power Query for Excel 2016.

Checkout my article on an Overview of Ability Query to learn more about this awesome tool!

Excel 2010 & 2013

For Excel 2010 and 2013 yous will need to download the Ability Query add-in and install it.

The installation steps are about the aforementioned in Excel 2010 and 2013.

Close (exit) Excel completely.
Click the following link to become to the download page.
http://world wide web.microsoft.com/en-us/download/details.aspx?id=39379
Click the Download push button.
Click the checkbox for the bit version yous are using. Most probable you lot will be using 32-bit.
Click Next
The add-in installation file volition download. Click the file to run the installation.
The Setup Magician window volition open. Follow the steps to install Power Query.
In one case the installation is consummate, open Excel. Y'all should at present run across the Power Query tab in the Ribbon.

My Ability Query Tab Disappeared

If your Power Query tab ever goes missing, yous can commonly re-enable the add-in by going to the COM Add-ins menu.

In that location are a few ways to get to the COM Add-ins menu.

File menu.
Click Options on left side menu.
Click Add-ins on left side menu.
Select COM Add-ins from the Manage drop-down.
Click the Go… button
That will open the COM Add-ins Window. If the Ability Query check box is not selected, but select it to reload the add together-in.

There is besides a button on the Developer tab that volition have you directly to this window.

Getting Started with Ability Query

Power Query is my favorite tool for working with data in Excel. If you are not familiar with what Ability Query can practise, checkout my article on an Overview of Power Query to acquire more.

Please leave a comment beneath with whatever questions.