Data type not working

Question

Hi everybody,

I am having a problem with my data type. The data type icon is suddenly not showing and when added through ribbon option it is not working. I have a excel file which perfectly worked until today - there are many stocks etc. I wanted to add one stock but I can not add a "stock type data" so I can see stock prices etc. I tried to do several things - reinstall, re-login, tried web excel, tried different excel file (also not working) - and nothing. Also, I browse through this community and nothing really helped.

I have mac air M1, now after reinstall also the newest version of Excel 365 (16.95).

Can anybody help me?

Thanks!

Answer 1

Hello.Trey_MK

Thank you for replying to my message.

I'm glad you could take my advice and solve the problem.

You can click ‘yes’ on both ‘yes’ and ‘no’ if you think my post was helpful.

Your feedback is very important to us.

Thank you for your co-operation.

Best regards.

Petter.Y - MSFT | Microsoft Community Support Specialist

Answer 2

Hello.Trey_MK

Thanks for using Microsoft products and posting in the community.

I would be honoured to help check your question.

Before I answer your question, you need to give me some information so I can better pinpoint your problem.

What's the version number of your mac?

To use this feature, you need your account to be subscribed to Microsoft 365,

1.Check the subscriptions in the account

Open the https://account.microsoft.com/. Login to your personal account Click "Services & Subscriptions".

Scroll down to see if you have Mircosoft 365 or Office subscription.

Do you have a subscription for Microsoft 365?

If you have a subscription, please log in to your account to use Microsoft 365.

Also if you are logged in to another office account, you can remove Office license files.

How to remove Office license files on a Mac - Microsoft Support

Also I provide some old version of office for mac installer, You can try old office to see if there are any restrictions:

Update history for Office for Mac - Office release notes | Microsoft Learn

Best regards.

Petter.Y - MSFT | Microsoft Community Support Specialist

Answer 3

Thank you! I reinstall it with older version and it is working now. Thanks