Hi,
Did the option gray out in Excel for mac?
You can try to sign out the current license and then re-sign in the license, use the Menu Bar and choose Excel- Sign Out- then Restart your Mac.
You can also suggest you post this issue to Copilot for Microsoft 365 forum:
https://techcommunity.microsoft.com/t5/copilot-for-microsoft-365/ct-p/Microsoft365Copilot
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
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.