How to Fix Excel Get Data From Online Services Grayed Out
Question details
The user needs to restore the 'From Online Services' data import option in Excel, which has become unavailable or disabled.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to import data from online services such as Salesforce using Power Query after a recent system or Office upgrade.
- Observed behavior
- The 'From Online Services' option under the Data > Get Data menu is grayed out and cannot be clicked.
Ensure you have an active internet connection and have the correct email and password for the work or school account assigned to your Microsoft 365 subscription.
Sign Out and Sign Back In to Your Microsoft Account
Re-authenticating your account clears up conflicting Microsoft 365 licenses that can cause Power Query features to be disabled.
Often, upgrading Windows or Microsoft 365 can cause conflicting login sessions, especially if you have multiple accounts. Signing out completely removes the corrupted session state.
Launch Microsoft Excel. Click on 'File' in the top-left corner, then select 'Account' from the menu on the left sidebar.
Under the 'User Information' section, click the 'Sign out' link. If you see multiple accounts listed, ensure you sign out of all of them, then close Excel entirely.
Reopen Excel and navigate back to 'File' > 'Account'. Click 'Sign In' and enter the credentials for the account that holds the correct Microsoft 365 license. Check the 'Get Data' menu to see if the option is restored.

Verify Microsoft 365 License Compatibility
Check your Microsoft 365 subscription tier, as certain online connections (like Salesforce) are restricted to Enterprise licenses.
Try WPS Office for Seamless Spreadsheet Management
If Microsoft Excel's licensing restrictions and complex account conflicts are slowing down your workflow, consider WPS Office. It is a free, lightweight alternative that provides robust spreadsheet tools, high compatibility with standard formats, and a familiar user interface without the need for expensive enterprise subscriptions.
- 1. Download the Installer: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install and Launch: Run the installer to set up WPS Office, then launch the WPS Spreadsheets application.
- 3. Open Your Files Seamlessly: Open your existing Excel workbooks directly in WPS Spreadsheets and continue analyzing your data without compatibility issues.

Frequently Asked Questions
Why is 'Get Data from Online Services' missing or grayed out in Excel?
This usually happens due to a licensing conflict where Excel logs into an incorrect account, or because your current Microsoft 365 subscription tier does not support certain enterprise data connectors.
Does Microsoft 365 Business Premium support Salesforce data imports?
No. Microsoft 365 Apps for Business and Business Premium editions do not support importing Salesforce objects and reports via Power Query. This feature is exclusive to Office Professional Plus and Microsoft 365 Apps for Enterprise.
How do I check which Microsoft 365 license I am currently using in Excel?
You can check your license by opening Excel, clicking on 'File' in the top-left menu, and selecting 'Account'. Your license tier will be displayed on the right side of the screen under 'Product Information'.




