Power Query is an amazing data tool for Excel! It is built by Microsoft lớn help you import, transkhung, & automate your data processes. Checkout my overview of nguồn Query to lớn learn more about it.

Bạn đang xem: Install excel 2010 power pivot

Here is a quichồng danh sách of compatible versions:

“Free” add-in for Excel 2010 and 2013 for Windows.nguồn Query is not yet available for the Mac versions of Excel.


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

Video Guide khổng lồ Installing Power Query

What Version Do I Need?

The download page for nguồn Query lists which version of Excel are compatible with Power Query.

Xem thêm: Dược Khoa Dược Tiếng Anh Là Gì, Dược Khoa In English, Khoa Dược Tiếng Anh Là Gì

The following Office versions for Windows are supported:

Microsoft Office năm 2016 – All VersionsMicrosoft Office 2013 – All VersionsMicrosoft Office 2010 Professional Plus with Software Assurance

Both 32-bit & 64-bit are supported. Power Query is not compatible with any Mac versions of Excel yet.

Unfortunately, if you don"t have these versions you will need khổng lồ upgrade lớn use nguồn Query. To me, Power Query is worth the tăng cấp lớn Office 365 alone, and there are a lot of other cool new features too.

How Do I Chechồng My Version of Excel?

Excel 2010

Here"s how khổng lồ determine your version and 32 or 64 bit in Excel 2010:

Cliông chồng the File button.Click the Help option on the left side thực đơn.The Excel version will be listed under the Product Activated section.The bit version (32-bit or 64-bit) will be listed under the About Microsoft Excel section.


If your Excel looks like the screenshot above, then you are in luck!

Bài viết liên quan

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *