'%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 the Disabled 'Data From Picture' Button in Excel
Question details
The user needs to restore the functionality of the Data From Picture feature in Excel so they can extract and insert data from images.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to insert table data from an image file or clipboard while signed into a Microsoft account.
- Observed behavior
- The 'From Picture' button is disabled or grayed out in the ribbon, preventing the user from using the feature, even though it may work when signed out or on a different account.
Make sure you have an active internet connection and your Microsoft account credentials ready, as resolving this issue involves syncing cloud privacy settings and potentially restarting the application.
Enable Connected Experiences in Account Privacy Settings
The 'From Picture' feature relies on Microsoft's cloud servers to analyze image content. Enabling Connected Experiences will grant Excel the necessary permissions to process your images.
Privacy settings in Microsoft 365 can restrict certain cloud-based features. If 'Experiences that analyze your content' is turned off for your account, Excel will disable the Data From Picture button to prevent unauthorized uploads.
Open Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Account' from the left-hand menu.
Under the 'Account Privacy' section, click on the 'Manage Settings' button.
Scroll through the privacy options and check the boxes for 'Experiences that analyze your content' and 'Experiences that download online content'.
Scroll down further to find the 'All connected experiences' section. Ensure the box for 'Turn on all connected experiences' is checked, click 'OK', and then restart Excel to apply the changes.
Perform a Quick or Online Repair of Microsoft 365
If privacy settings are correct but the button remains disabled, corrupted installation files might be the cause. Using the built-in repair tool can fix software glitches.
Extract Data from Pictures Easily with WPS Office
If Microsoft Excel continues to block the 'From Picture' feature due to account sync or privacy issues, try WPS Office. WPS Spreadsheets offers a highly accurate, built-in OCR (Optical Character Recognition) tool to instantly convert pictures into editable tables without complex account configurations.
- 1. Open WPS Spreadsheets: Launch WPS Office and open a new or existing spreadsheet.
- 2. Select Picture to Text: Navigate to the 'Data' or 'Tools' tab and click on the 'Picture to Text' or 'Screen Picture to Table' option.
- 3. Convert Image: Upload your image or take a screenshot. WPS will automatically analyze the image and populate the data directly into your cells.
Frequently Asked Questions
Why is the Data From Picture button grayed out on one account but works on another?
This happens because privacy settings and 'Connected Experiences' are tied to individual Microsoft accounts. If one account has restricted cloud content analysis, the feature will be disabled, while an unrestricted account will have full access.
Does the Data From Picture feature require an active internet connection?
Yes. Excel's 'From Picture' feature relies on Microsoft's cloud servers to perform Optical Character Recognition (OCR). It uploads the image, extracts the text, and sends it back to your spreadsheet, which requires a stable internet connection.
Will repairing Microsoft 365 delete my Excel files?
No, running a Quick Repair or Online Repair from the Windows Control Panel only fixes the application's underlying program files and registry keys. Your personal Excel workbooks and data will remain completely unaffected.
What should I do if the button is still missing after enabling connected experiences?
If the button is still disabled or entirely missing, go to File > Account > Update Options and click 'Update Now' to ensure you are on the latest version. Additionally, check File > Options > Add-ins to ensure no conflicting third-party COM Add-ins are interfering with the feature.
