Are Power Query and Power Pivot Included in Office Home and Business?
Question details
User wants to know if Power Query and Power Pivot features are available in the Excel desktop application provided with Microsoft Office Home and Business.
- Product
- Microsoft Office Home and Business
- Device & OS
- Windows 11 Home and Pro
- Scenario
- Planning to purchase Office Home and Business and verifying if it meets advanced data analysis requirements.
- Observed behavior
- Seeking confirmation on feature availability across different Microsoft Office editions and Windows operating system versions before purchasing.
Identify the exact version of Microsoft Office you plan to purchase or currently have installed, as feature availability can vary significantly between Mac and Windows versions.
Verify Power Query and Power Pivot Availability
Understand which editions of Office include these advanced data features and how your OS affects them.
Excel in Office Home and Business 2019 and Office Home and Business 2021 for Windows does include both Power Query and Power Pivot. These editions provide the full desktop versions of Excel.
The Windows operating system edition you use (such as Windows 11 Home versus Windows 11 Pro) does not determine or restrict the availability of these Excel features. If your Office suite supports them, they will work on either OS tier.
Confirm that you are purchasing or using Office Home and Business 2019 or 2021, which provides the full desktop versions of Word, Excel, PowerPoint, and Outlook for Windows.
Open Excel, navigate to the 'Data' tab on the ribbon, and look for the 'Get & Transform Data' group to access Power Query features.
Go to File > Options > Add-Ins. In the Manage box, click 'COM Add-ins' and select Go. Check the box for 'Microsoft Power Pivot for Excel' and click OK to add the Power Pivot tab to your ribbon.
Try WPS Office for Your Spreadsheet and Document Needs
If you are evaluating Office suites for your home or business, consider WPS Office. It provides a lightweight, highly compatible alternative for Word, Excel, and PowerPoint tasks without complex licensing tiers.
- 1. Download the installer: Visit the official WPS Office website and download the free installation package for Windows.
- 2. Install the software: Run the downloaded setup file and follow the simple on-screen instructions to complete the installation.
- 3. Open existing files: Launch WPS Spreadsheets and directly open your existing Excel workbooks to continue editing without formatting loss.
Frequently Asked Questions
Does Windows 11 Home restrict Excel features like Power Query?
No, the edition of your Windows operating system (Home or Pro) does not restrict Excel features. Power Query and Power Pivot availability is determined solely by your Office license and version.
What is the difference between Office Home and Business and Office Professional?
Office Home and Business includes the core apps: Word, Excel, PowerPoint, and Outlook. Office Professional includes all of those core apps plus Microsoft Access and Publisher, which are available on Windows only.
Are Power Query and Power Pivot available on Excel for Mac?
Power Query has been gradually introduced to Excel for Mac, allowing you to refresh and create queries, but the full Power Pivot data modeling experience remains exclusive to the Windows desktop versions of Excel.
