#Excel 2016 ribbon editor how to
#Excel 2016 ribbon editor 64 Bit
#Excel 2016 ribbon editor upgrade
#Excel 2016 ribbon editor software

There are a few ways to get to the COM Add-ins menu. If your Power Query tab ever goes missing, you can usually re-enable the add-in by going to the COM Add-ins menu. You should now see the Power Query tab in the Ribbon. Once the installation is complete, open Excel.The add-in installation file will download.Click the checkbox for the bit version you are using.Click the following link to go to the download page.The installation steps are about the same in Excel 20.

#Excel 2016 ribbon editor how to

Hopefully this guide helps you figure out how to get Power Query for Excel 2016.Ĭheckout my article on an Overview of Power Query to learn more about this awesome tool! Excel 2010 & 2013įor Excel 20 you will need to download the Power Query add-in and install it. Here is an article on how to switch channels.Īll the versions and channels make this very confusing, to say the least. Here is an article about the different channels for Office 365 ProPlus. This means you get updates every six months instead of every month. The name of the Deferred Channel has been changed to Semi-Annual Channel as of September 2017. If you are on the ProPlus version of Office 365 then you might be on the Deferred Channel. Here is an article on how to determine which version of 2016 your are on.

If you are on an Office 365 subscription then you have the Click-to-run version and you should get all the latest updates. Your ribbon might look different from mine, and you won't have all the latest features. If you are on the MSI (Windows Installer) version then you will not get frequent updates to Power Query. It's important to note that there are some differences in Power Query for different builds of Excel 2016. Here is an article that explains the features available for each subscription level. Power Query is available with all levels of Office 365 subscriptions. If you are using Excel 2016, go to the Data tab on the ribbon and press the New Query button to create a query and open the Power Query editor. It has been renamed and is now on the Data tab of the Ribbon in the Get & Transform section. Power Query is included with Excel 2016 (Office 365). The bit version (32-bit or 64-bit) will be listed in the first row of the pop-up window.

The Excel version will be listed under the Subscription Product section.

Click the Account option on the left side menu.

#Excel 2016 ribbon editor 64 Bit

Here's how to determine your version and 32 or 64 bit in Excel 2013: If your Excel looks like the screenshot above, then you are in luck! 🙂 Again, you will need the Professional Plus version of Excel 2010.

The bit version (32-bit or 64-bit) will be listed under the About Microsoft Excel section.

The Excel version will be listed under the Product Activated section.

Click the Help option on the left side menu.

Here's how to determine your version and 32 or 64 bit in Excel 2010: How Do I Check My Version of Excel? Excel 2010

#Excel 2016 ribbon editor upgrade

To me, Power Query is worth the upgrade to Office 365 alone, and there are a lot of other cool new features too. Unfortunately, if you don't have these versions you will need to upgrade to use Power Query.

Power Query is not compatible with any Mac versions of Excel yet.

#Excel 2016 ribbon editor software

Microsoft Office 2010 Professional Plus with Software Assuranceīoth 32-bit and 64-bit are supported.

The following Office versions for Windows are supported: The download page for Power Query lists which version of Excel are compatible with Power Query. This page will help you determine if you have the right version of Excel, and provide installation instructions.

Power Query is not yet available for the Mac versions of Excel.

Built-in feature for Excel 2016 for Windows (Office 365 Subscription).

“Free” add-in for Excel 20 for Windows.

Here is a quick list of compatible versions: Checkout my overview of Power Query to learn more about it. Power Query is an amazing data tool for Excel! It is built by Microsoft to help you import, transform, and automate your data processes.