You create a new local windows profile with the clean environment to check if the If the suggestion above doesn’t work, to narrow down this issue is related to old user profile in your Windows, we’d suggest.Please click on the link below to access your private message. At the same time, you can also go to C:\Program Files (x86)\Microsoft Office\root\Office16\Library\Analysis orĬ:\Program Files\Microsoft Office\root\Office16\Library\Analysis upload your ANALYS32.XLL, we can also test it on our side to check if this issue is related to yourĪNALYS32.XLL file.
We will provide the ANALYS32.XLL file via private message, you can download it, then you can go to Excel > File > Options > Add-ins > Excel Add-ins > Go > click Browse to select the file we provided to check if the same problem.On the one hand, we’d also want to provide additional two suggestions below and we hope that will help you solve the problem: Given this situation, we’re sorry the inconvenience caused by it. And the engineer is also trying his best to helping you. We have read your communication records, it seems that you have also tried re-activating Office. Thank you for sharing the ticket number with us via private message. Your understanding and patience will be highly appreciated. If it is convenient to you and you can share the ticket number with us, we will also monitor the issue according to the ticket number you provided. If we have any updates, we will post back. We may need some time to do more research and test. Per your description, it seems that you have tried all suggestions we provided above. Īt the same time, we also appreciate that you spent your precious time doing those tests. I have sent the private message via priavte message link, you canĪlso click this link again to access the message i sent to you. We’re also sorry that the link of private message confused you.
We are sorry the inconvenience caused by it. We appreciate that you posted back and shared the detailed information with us. * Once complete conversation about this topic, kindly Mark and Vote any replies to benefit others reading this thread.
* Beware of scammers posting fake support numbers here. Thank you for your understanding and patience. Please click on the link below to access your private message : private message/inbox. You mentioned that you have called Microsoft support, to protect your private information, our engineer has masked the ticket number you provided, to better understand your situation and monitor this issue, we also want to collect the ticket numberĪgain via private message.To test it on our side, could you provide the Product Information and version of your Excel? You can go to Excel > File > Account and provide the screenshot of it.If the suggestion above doesn’t work, to better understand your situation and narrow down this issue, could you also provide the information below? For your reference:ĭata analysis will not show up even with analysis toolpak and analysis tool-vba installed. Someone encountered the similar issue and solved the problem via going to Excel > File > Options > Add-ins to uncheck Analysis Toolpak and select it again to check if the same problem will occur.
May I know if your problem has been solved? If not, we noticed that there is no comment under your last reply, we understand the inconvenience caused and apologize for it, we will try our best to help you.Īccording to your description, it seems that you have enabled Analysis Toolpak add-ins in Excel, however, you cannot find it under Data tab.