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.
How to load analysis toolpak into google sheets update#
May I know if my understanding is right? If so, we have tested it on our side with the latest version of Excel Current Channel 2005(12827.20336), we can see Data Analysis under Data, as shown below: You also tried rebooting computer, and same problem still persists. Trust center settings and customizing the ribbon to see if it was unchecked to display, however, they didn’t work. And you have tried repairing Excel, reinstalling Excel, disabling he "Disable all Add-ins" option in the microsoft 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.