'%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)
Fix Missing 'From Online Services' Option in Excel Business Premium
Question details
The user is unable to locate the 'From Online Services' option under the Get Data menu in Excel, despite holding a Microsoft 365 Business Premium license.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to import data from online services using the Power Query 'Get Data' feature.
- Observed behavior
- The 'From Online Services' option is missing from the Data > Get Data menu, whereas it is visible to other colleagues utilizing the exact same license.
Before making system changes, verify your exact Office version and build number in the Account settings, and ensure you are actively logged into Excel with your primary Microsoft 365 Business Premium credentials.
Verify Office Version and Update Channel
Ensure your Excel installation is on the correct update channel, as feature availability often varies between Microsoft 365 rollout channels.
Even users with identical licenses can experience different feature sets if they are assigned to different update channels (e.g., Current Channel vs. Semi-Annual Enterprise Channel).
Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' at the bottom of the left-hand navigation pane.
Look under 'Product Information' to see your current Update Channel. Note the channel name and the specific version/build number.
Compare this channel and version number with a colleague who currently has the 'From Online Services' feature. If your version is older, click 'Update Options' and select 'Update Now' to download the latest features.
Refresh License and Account Assignment
Clear potential caching issues by signing out and signing back into your Microsoft 365 account to refresh your enterprise feature entitlements.
Review IT Deployment Configuration
If Office was deployed by your IT department via Intune or the Office Deployment Tool (ODT), specific connectors may have been excluded from the installation.
Try WPS Office for Seamless Data Management
If Microsoft Excel's enterprise features are causing deployment headaches or missing options based on complex update channels, consider switching to WPS Office. It provides a highly compatible, user-friendly spreadsheet experience without hidden license-dependent feature toggles.
- 1. Download WPS Office: Visit the official WPS website and click the 'Free Download' button.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Excel data files to resume your work.
Frequently Asked Questions
Why do my colleagues have Excel data features that I don't, despite having the same license?
Feature availability in Microsoft 365 is often tied to your specific Office Update Channel (e.g., Current Channel vs. Semi-Annual Enterprise Channel). Even with identical licenses, users on different update channels will receive new features at different times.
How do I force Excel to update and get the latest data connectors?
Open Excel, navigate to File > Account, click on 'Update Options' under Product Information, and select 'Update Now'. This process downloads and installs the latest features authorized for your specific update channel.
What should I do if updating Excel does not restore the 'From Online Services' option?
If a standard update doesn't work, try signing out of your Microsoft account within Excel and signing back in to refresh your license. If the issue persists, contact your IT administrator to check if Group Policies or Office Deployment Tool settings are actively hiding the feature.
Can a corrupted Office installation cause missing menu options?
Yes, a corrupted installation can occasionally cause UI elements and data connectors to disappear. You can resolve this by running an Online Repair: go to Windows Settings > Apps, find Microsoft 365, select Modify, and choose 'Online Repair'.
