What version of office do you use? If you use excel 2016/office 365, then this function will be subject to certain restrictions.
Currently the most suitable version is to use office 2013.
If an Answer 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.
Hi @Alexandra Popescu
Try to repair your Office, first try a quick repair (it takes 5 to 10 minutes), if this does not help, then try an online repair (usually more than 30 minutes, but usually less than 1 hour)
https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b?ui=en-US&rs=en-US&ad=US