This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I want to use the 'Data Types' (in the data section) in excel but I can't click on it. It is there but in grey so I can't access it. What could be the issue?
Many thanks in advance for your responses
Agathe
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
What version of office are you using?
In safe mode the same problem happens?
Open the Run dialog box by pressing the Windows key + R. ...
Once the Run window opens, type:
excel /safe in the input box next to 'Open'.
Press the Return key or click OK
I already tied. The issue is still there opening up an excel file with or without being logged.
log off your account and log in again, and see if the function works again.
Hi Andre,
Thanks for your response.
Format is .xlsm and creating a new file the issue is still there.
At first Data types wasn't showing in the Datas tools (apparently it should) so I created manually a group to add it. Telling you that in case it could help solving if it is related to the issue.
Hi
My name is André. I am an independent consultant.
What is the format of the file being treated, .xlsx?
If you create a new file, from scratch, the option also does not appear?
Answer here so I can continue helping you.
André.