'%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 Microsoft 365 Excel Analyze Data and Data from Picture Features Missing
Question details
The user is unable to locate or use the Analyze Data and Data from Picture features in Microsoft Excel 365.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Trying to use AI-powered data analysis or image-to-data extraction features in the Excel Home tab.
- Observed behavior
- The Analyze Data button is missing from the Excel ribbon, and the Data from Picture option is unavailable, likely due to disabled connected experiences.
Verify whether you are using a personal Microsoft account or an organizational (work or school) account, as these connected features are often heavily regulated by enterprise privacy policies.
Enable Connected Experiences or Contact Your IT Administrator
These features require Microsoft's connected experiences to be active. If you are on an enterprise account, your IT admin may need to enable them.
Features like Analyze Data and Data from Picture rely on Microsoft's cloud servers to process your content. If privacy policies restrict these 'connected experiences', the buttons will disappear from your ribbon.
Launch Microsoft Excel, click on the 'File' menu, and select 'Options' at the bottom left corner.
Select 'Trust Center' from the left navigation pane and click on the 'Trust Center Settings' button.
Click on 'Privacy Options' in the left pane, then click on the 'Privacy Settings' button.
Scroll down to the 'Connected Experiences' section and check the box for 'Turn on experiences that analyze your content'. Click OK to save and restart Excel.
If the checkbox is greyed out or missing, you are restricted by organizational policies. Contact your Microsoft 365 IT administrator and request them to enable connected experiences.
Try WPS Office for Seamless Data Processing and OCR
If enterprise restrictions are blocking your workflow in Microsoft Excel, try WPS Office. It's a free, lightweight, and highly compatible alternative that offers powerful data tools and built-in OCR features without complicated IT administration lockouts.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files directly with complete format compatibility.
- 3. Use Smart Tools: Access built-in tools like Picture to Text (OCR) from the Tools tab without worrying about admin restrictions.
Frequently Asked Questions
Why is the Analyze Data button missing in my personal Excel 365 account?
For personal accounts, the feature might be hidden if connected experiences are turned off in your Privacy Settings. Go to File > Account > Account Privacy > Manage Settings to ensure they are enabled.
Does Data from Picture work without an internet connection?
No. Data from Picture is a cloud-based connected experience that requires an active internet connection to send the image to Microsoft's servers for optical character recognition (OCR).
Is Analyze Data available in older versions of Excel?
Analyze Data is an AI-powered feature exclusive to Microsoft 365 subscribers. It is not available in standalone perpetual versions like Office 2019 or Office 2016.
