Fix the Missing Active Directory Connector in Microsoft 365 Excel
Question details
Find or restore the From Active Directory data connector in Microsoft 365 Excel.

- Product
- Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- The user wants to import Active Directory data through Excel's Get Data interface.
- Observed behavior
- The From Active Directory option is missing, including after Office was updated and reinstalled.
Open Excel and check File > Account for the installed Office version and update channel. Menu names and connector availability can vary by platform and Microsoft 365 release.
Check Excel's Get Data Menu and Ribbon Settings
Look for the connector in its current menu location and check whether the command is available for the ribbon.
In Excel, select Data > Get Data and look under From Other Sources for From Active Directory.
If the option is missing, open File > Options > Customize Ribbon. Under Choose commands from, select All Tabs, then expand Data > Get & Transform Data > Get Data and look for From Active Directory.
If the command appears in the list but not on the ribbon, add it to a custom group using the Add button, then select OK.

Verify the Microsoft 365 Build and Update Channel
Use this check to rule out an outdated build or an update channel that has not received the relevant functionality.
Confirm Active Directory Connector Support
If updating and reinstalling have not restored the connector, check whether it is supported in your environment.
Work With Exported Directory Data in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Excel formats. If your administrator can export directory data to a spreadsheet or CSV file, you can open and work with it in WPS Spreadsheets. WPS does not restore Excel's Active Directory connector.

Frequently Asked Questions
Where should the Active Directory connector appear in Excel?
When available, look under Data > Get Data > From Other Sources > From Active Directory. The location and availability can vary by platform and release.
Can I add the connector back through Customize Ribbon?
Open File > Options > Customize Ribbon and look under All Tabs > Data > Get & Transform Data > Get Data. If the command is listed, you can add it to a custom group. If it is not listed, ribbon customization cannot make it available.
What should I check if reinstalling Office did not help?
Open File > Account and About Excel to record your version and build. Then ask your administrator or Microsoft Support to verify the update channel, platform, license, and connector availability.
Can WPS Office fix the missing Excel connector?
No. WPS Office cannot restore a Microsoft Excel connector. However, WPS Spreadsheets can open directory data exported separately to formats such as XLSX or CSV.




