I can not use Excel Data type (can't click it) mac

Julian Clemens 1 Reputation point
2022-06-20T06:19:30.763+00:00

Hi I've been trying to connect some data with my excel docs but my data type section does not exist. Therefore I created a new group to at Data type there but I can't click on it. In the image below you can find the data type section on the right side.
212814-screenshot-2022-06-20-at-151551.png

I'd like to get some help and would really appreciate it!
Thanks

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,758 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 27,871 Reputation points Microsoft Vendor
    2022-06-22T02:37:57.177+00:00

    Hi @Julian Clemens ,
    What's the version of Excel for Mac are you using? I suggest you go to Excel- About Excel and check the version information:
    213644-16.png
    213559-15.png
    Make sure the Excel for Mac is up-to date on Mac OS.
    Then you can go to Go to Excel- Preferences- Privacy and make sure Connected Serves is enabled.
    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.