'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Is Power Query Available in Excel for Mac LTSC 2021?
Question details
The user wants to know if Power Query features are supported in Excel for Mac LTSC 2021 and how to enable or access them.
- Product
- Excel for Mac LTSC 2021
- Device & OS
- Mac
- Scenario
- Attempting to import and process data using Power Query in a perpetual license version of Excel on a Mac.
- Observed behavior
- Power Query options are missing from the Data menu, as feature availability varies by exact build, update channel, and license type.
Verify your exact Excel version by clicking 'Excel' > 'About Microsoft Excel' from the top menu, and ensure your Mac has an active internet connection to download potential software updates.
Update Excel to Version 16.76 or Later
Updating Office LTSC Standard for Mac 2021 to recent Current Channel builds often resolves missing Power Query features.
Power Query features were introduced to perpetual Mac licenses in later builds. Testing confirms that versions 16.76 and 16.77 enable these capabilities. Note that if you are in a corporate environment, your IT department may control which update channel is available to you.
Open Excel on your Mac. Go to the top menu bar, click on 'Help', and select 'Check for Updates'.
In the AutoUpdate window, click 'Advanced' if necessary, and ensure your update channel is set to 'Current Channel'.
Click 'Update' to download and install the latest versions. Make sure your build reaches at least 16.76.
Restart Excel, open a workbook, and navigate to the 'Data' tab to see if the 'Get Data' (Power Query) options are now visible.
Use Built-in Microsoft Query and ODBC
If you cannot update to a newer build, you can use the legacy Microsoft Query tool and ODBC drivers as an alternative to Power Query.
Try WPS Office for a Hassle-Free Data Processing Experience on Mac
Dealing with confusing update channels and delayed feature rollouts in Excel for Mac LTSC can be frustrating. WPS Office provides a lightweight, fast, and feature-rich alternative for Mac users without complex license restrictions.
- 1. Download WPS Office: Visit the official WPS Office website and download the Mac version for free.
- 2. Install on your Mac: Open the downloaded installer package and drag the WPS Office icon to your Applications folder.
- 3. Open Your Excel Files: Launch WPS Spreadsheets and open your existing .xlsx files to instantly resume your data analysis.
Frequently Asked Questions
Why is Power Query on Excel for Mac different from Windows?
Microsoft maintains different development schedules for Mac and Windows. As a result, new data processing features and Power Query enhancements typically arrive on the Windows version first before being ported to Mac.
Do I need a Microsoft 365 subscription to use Power Query on Mac?
While full feature parity and instant updates require a Microsoft 365 subscription, recent updates (versions 16.76+) for the perpetual Office LTSC Standard for Mac 2021 have introduced basic Power Query capabilities via the Current Channel.
How do I check my current Excel for Mac version?
Open Excel, click on the 'Excel' menu in the top-left corner of your screen, and select 'About Microsoft Excel'. A dialog box will display your exact version number and license type.
Why is PivotTable behavior different in Office LTSC?
Perpetual licenses like Office LTSC are 'locked-in-time' releases. They generally receive security patches but not new feature updates. Therefore, some advanced PivotTable features available to Microsoft 365 subscribers may be absent.
