"Data from Picture" button missing

Question

Hi,

I'm using the latest version of Excel on mac. However, the "Data from picture" button is missing from both the "Insert" tab and "Data" tab in the menu. How could I get access to it? I've already tried reinstalling the whole Microsoft Office but it didn't help at all.

Thanks!

Answer 1

I'm afraid "latest version" is a relative term any more based on type of license & macOS version:-) Please go to Excel> About Microsoft Excel in the main menu to determine the type of License. My understanding is that the feature is available only in the subscription software so if your license is anything other than Microsoft 365 Subscription that would explain why you don't have it.

Answer 2

Data from picture is not on the Data menu, but you will find it on the Data TAB of the Ribbon if you have the current update to Excel installed (16.57) and you have an Office 365 subscription.

As Bob said, check your version and license type by going to the Excel menu and choosing About Excel. We think either you don't have version 16.57 or your license type is something other than Office 365 Subscription.

Answer 3

Hi Jim, this is so odd.

I checked the excel version and it is indeed 16.57 and it is Microsoft Office 365 subscription. Nevertheless, this feature is fully missing from my excel.

Answer 4

Go to Excel > Preferences > Privacy and make sure optional connected experiences is enabled.