'%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)
How to Fix From Picture Greyed Out in Excel 365
Question details
The 'From Picture' (Data from Picture) feature is greyed out and unavailable to use in Excel 365.
- Product
- Excel 365
- Device & OS
- not provided
- Scenario
- Attempting to extract table data from an image using the 'From Picture' tool in the Data tab.
- Observed behavior
- The 'From Picture' option is greyed out and unclickable in the ribbon, and the issue persists even after uninstalling and reinstalling Microsoft Office.
Ensure your Microsoft 365 subscription is active and that you have a stable internet connection, as the 'From Picture' feature requires cloud connectivity to analyze images.
Enable Connected Experiences in Privacy Settings
The 'From Picture' feature requires Microsoft's cloud-based Connected Experiences. If this privacy setting is disabled, the button will be greyed out.
Extracting data from a picture relies on Microsoft's cloud servers to process the image. Disabling 'Connected Experiences' to maximize privacy will directly disable this feature. Restoring this setting is the most common fix for the issue.
Launch Excel, click on 'File' in the top left corner, and select 'Options' at the bottom left. In the Excel Options window, click on 'Trust Center' and then the 'Trust Center Settings' button.
In the Trust Center window, navigate to 'Privacy Options' on the left sidebar, and click on the 'Privacy Settings' button.
Scroll down to the 'Connected Experiences' section. Check the boxes for 'Turn on experiences that analyze your content' and 'Turn on all connected experiences'.
Click 'OK' to save the changes, then completely close and restart Excel 365 to apply the new privacy settings and reactivate the feature.
Repair the Microsoft Office Installation
If adjusting the privacy settings doesn't work, a quick or online repair can fix underlying corrupted Office files.
Try WPS Office for Seamless Data Extraction
If Excel's 'From Picture' feature keeps greying out due to account limitations or privacy setting issues, consider WPS Office as a free and lightweight alternative. WPS Spreadsheet offers excellent format compatibility and features built-in OCR tools, allowing you to extract data from images without dealing with complex cloud privacy configurations.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your computer.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and open a new or existing workbook where you want to insert your table data.
- 3. Use Picture to Text Tools: Navigate to the Tools or Data tab and use the built-in OCR or Picture to Text features to instantly convert image data into your spreadsheet.
Frequently Asked Questions
Why did 'From Picture' stop working after an Office update?
Office updates can sometimes reset your privacy settings or sign you out of your Microsoft account. Since 'From Picture' requires an active account and connected cloud experiences, a reset setting will cause the feature to grey out until manually re-enabled.
Can organizational policies disable the From Picture tool?
Yes. If you are using a work or school account, your IT administrator may have applied group policies that restrict connected experiences. This will grey out cloud-dependent features like 'From Picture', and you will need to contact your IT admin to enable it.
Does the 'From Picture' feature work offline in Excel 365?
No. The 'From Picture' feature requires an active internet connection. It relies on Microsoft's cloud-based image analysis to accurately recognize and extract tabular data from your pictures. If you are offline, the button may become unavailable.
