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.