Dont Upload Certain Query Into Power Query
Power Query is an amazing data tool for Excel! It is built by Microsoft to help yous import, transform, and automate your data processes. Checkout my overview of Ability Query to learn more nearly it.
Here is a quick list of compatible versions:
- "Free" add-in for Excel 2010 and 2013 for Windows.
- Born characteristic for Excel 2016 for Windows (Office 365 Subscription). Click here to larn where to find information technology.
- Power Query is not yet bachelor for the Mac versions of Excel.
This page volition help you lot determine if you have the right version of Excel, and provide installation instructions.
Video Guide to Installing Ability Query
What Version Do I Demand?
The download page for Power Query lists which version of Excel are uniform with Power Query.
The post-obit Function versions for Windows are supported:
- Microsoft Office 2016 – All Versions
- Microsoft Part 2013 – All Versions
- Microsoft Part 2010 Professional person Plus with Software Assurance
Both 32-flake and 64-scrap are supported. Power Query is not compatible with whatever Mac versions of Excel yet.
Unfortunately, if you don't have these versions you lot volition need to upgrade to use Power Query. To me, Ability Query is worth the upgrade to Role 365 alone, and there are a lot of other absurd new features also.
How Do I Check My Version of Excel?
Excel 2010
Hither's how to determine your version and 32 or 64 bit in Excel 2010:
- Click the File button.
- Click the Assistance selection on the left side carte du jour.
- The Excel version will be listed nether the Product Activated section.
- The bit version (32-bit or 64-bit) volition exist listed nether the Nearly Microsoft Excel section.
If your Excel looks similar the screenshot above, then you lot are in luck! 🙂 Again, y'all volition need the Professional Plus version of Excel 2010.
Excel 2013
Hither's how to determine your version and 32 or 64 fleck in Excel 2013:
- Click the File button.
- Click the Account selection on the left side menu.
- The Excel version will be listed nether the Subscription Production section.
- Click the About Excel push button. The chip version (32-bit or 64-bit) will exist listed in the first row of the popular-upwardly window.
How to Install Power Query
Excel 2016
Power Query is included with Excel 2016 (Office 365). It has been renamed and is now on the Data tab of the Ribbon in the Become & Transform section.
This ways in that location is nothing to install. If you are using Excel 2016, get to the Data tab on the ribbon and printing the New Query button to create a query and open up the Ability Query editor.
Ability Query is bachelor with all levels of Office 365 subscriptions. Hither is an article that explains the features bachelor for each subscription level.
Information technology's of import to note that there are some differences in Ability Query for different builds of Excel 2016.
If you lot are on the MSI (Windows Installer) version then y'all will not get frequent updates to Power Query. Your ribbon might expect different from mine, and you won't have all the latest features.
If you lot are on an Office 365 subscription then you lot accept the Click-to-run version and yous should get all the latest updates. Here is an article on how to determine which version of 2016 your are on.
If y'all are on the ProPlus version of Office 365 then you might be on the Deferred Aqueduct. The proper noun of the Deferred Channel has been changed to Semi-Annual Aqueduct as of September 2017. This means y'all get updates every six months instead of every month.
Here is an commodity nigh the dissimilar channels for Office 365 ProPlus.
Hither is an article on how to switch channels.
All the versions and channels brand this very confusing, to say the to the lowest degree. Hopefully this guide helps you figure out how to get Power Query for Excel 2016.
Checkout my article on an Overview of Power 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 same in Excel 2010 and 2013.
- Close (exit) Excel completely.
- Click the post-obit link to become to the download page.
http://www.microsoft.com/en-the states/download/details.aspx?id=39379
- Click the Download button.
- Click the checkbox for the bit version you are using. About likely y'all will be using 32-bit.
- Click Next
- The add together-in installation file will download. Click the file to run the installation.
- The Setup Wizard window will open up. Follow the steps to install Power Query.
- Once the installation is complete, open Excel. You lot should now meet the Ability Query tab in the Ribbon.
My Power Query Tab Disappeared
If your Power Query tab ever goes missing, you can usually re-enable the add-in by going to the COM Add together-ins menu.
There are a few means to go to the COM Add-ins menu.
- File card.
- Click Options on left side menu.
- Click Add-ins on left side menu.
- Select COM Add-ins from the Manage drib-downwards.
- Click the Go… button
- That volition open up the COM Add together-ins Window. If the Power Query bank check box is non selected, only select it to reload the add together-in.
There is also a button on the Programmer tab that will accept y'all directly to this window.
Getting Started with Power Query
Power Query is my favorite tool for working with data in Excel. If you lot are not familiar with what Power Query tin do, checkout my article on an Overview of Ability Query to larn more.
Please leave a annotate below with any questions.
Source: https://www.excelcampus.com/install-power-query/