Data types disappear after MacOS update

Question

Last weekend I updated my Mac OS to Monterey 12.3.1. On Monday morning I opened an excel file with Stock Data types and realized that the values were not updating. Subsequently, I realized that the Data Types had disappeared from the ribbon under DATA. I have also tried adding Data types in the custom groups, but it remains greyed out and unusable.

This is the second time I have had this problem. The first time the issues were resolved after two weeks of attempting different solutions ranging from re-installing Excel, verifying that "optical connected experiences" was enabled, moving "com.microsoft.excel" to desktop, booting in safe mode and so on. None of these solutions have worked this time around.

As it stands, my files are unusabe. Any ideas of how I can resolve this issue?

Answer 1

Got a solution from Microsoft, I hope it works for you too:

Hello,
We are actively investigating this issue and are, at the moment, unsure what might have caused the Data Type feature to become disabled.
When you get a chance can you please follow these instructions and let me know if it brings back the Stock and Geography buttons?

1. Quit Excel and all other Office apps completely.
2. Open your Mac's System Preferences
3. Go to the Language & Region settings
4. Change the language to English and the Region to United States in the General tab (verify that Excel is not set to a different language under the Apps tab)
5. Restart you Mac
6. Launch Excel and check the Data ribbon tab for the Data Type buttons

If they are still missing. Quit and restart Excel and check again. If they are still missing, sign out of your Microsoft 365 account, sign back in then restart Excel.

Answer 2

Hi Pierre,

Sorry for the inconvenience that happened to you.

According to your description, you have already tried some steps to troubleshoot the issue. Please try the following suggestions and check if they help.

1. Based on my search, please try the steps in Miguel’s reply of this thread. Check if it helps.
2. Please switch to another Mac user profile (if you don’t have another user profile, please create a new Mac user profile, then switch to the new user profile), run Excel and check again.

Also, please make sure you have login in Office for Mac with account that have Microsoft 365 subscription.

Regards,

George

Answer 3

Hi Pierre,

I'm writing this reply to follow up on this thread. When you have time, you are welcome to come back and share any updates with us.

Regards,

George