![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcfp66SYY4goMeNhkT4laELTLCR5_ui2VBZ3ts2Mvv0MpaF4E1erI9LgdTqLAQ4x55g8tHypVU_N653acpIwJBxuCIj5G3zHQwF2wPsZN4wvp_4EfAF52Cs6IUgxExGQvSMGIsJrW6t2w/s400/office+button+2.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIwHQZovzwvCwXCWbUZPvgQImSB2cavZekWMJyMRYSXv0KNfDR_8doSQeWfBw79y8e_B3q0bpzqyftlX4dqy0bMvsQkLpg_B75_-TNJNwP7IztRDwWEYYJSMDcUmlX7n_DiXOUncwQI1E/s400/Addins+01.png)
Click Excel Options,
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilnS27k-rMpndD6wcRV6fHt88WKjUAKrxVaBeIqzQ88OAr2lhtulGbZqaqQA-ZWgm59Q8S93vOlJmRr_1PYj_V13uDszFCTzKSu-KRkrCkMsjfhXsrCrTgXHXarm0yLdj3j-VmwOK97HI/s400/Addins+02.png)
Select Add-Ins,
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEB-WLkyEyTP7uEI_lQwHu2KdaVNGUEKpqBSC6KE6ibB69mfW2PmjC1iiaUOTQrMCaMLZ1fiWq5R0dKj1a-wQBdy_keGAxsmhvb6Tg5yJXnVKSDQjRzY1i4tper8i93A1N7Lujlwg0qSo/s400/Addins+03.png)
In this case, Analysis Toolpak is behind the list of Inactive Application Add-ins. To install it, select the Analysis Toolpak then click Go... button.
And then you will see Add-Ins window like this below:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8vcjKYhPcVGTCBlRVOnRV3mIMmom1XKvQXPwOgVV8qwjcEbVK_uaX438k6p5YedMhVISKWQfrcYaq53eHD5CqJKdxmgR027CRATTt-opYv7vlbil9J5XeH5J2HT65AVEOlFg6DkDi43w/s400/Addins+04.png)
Check Analysis Toolpak (see picture below) then click OK button.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggzFx5eH-oQOsUi5up8qCbXTsXnJyG1JJColamqErhU3_Qh1NiSKiKUF9izJyqbIj2GHY3eX0qu6zne4iKy958TLZW7aa6aZ1Jz8Sx8KtUZnqQyoU0VexxYQ0VzUCXGfqYqswtnKq-VlU/s400/Addins+05.png)
And then warning window appear, click Yes button if you want to continue to install it or click No button if you want to cancel. In this case, I want to install it.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinM1XaQE3H_jkmjJ_CLZ_G3IBV13xNcpmngDIfEcY_-uU47-ImGeRavV3yhtmxlwHu9NTKfXB_wyTuZiqH0HPw3PvVuBJInF7N45yShyphenhyphenPrhYryn5V6h0A5UTUpb-FU7NJSeCV5UxZ09q4/s400/Addins+06.png)
Progress window will appear, wait a few second.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZe0PzWFzotr6KpqPT6CijkdiSdCgbGfYU9WEtY-yvtY9whpQx-_xK3cLlcLdQBhdpsFJrKmjz09_nJy5vzjJBasuaezmyB1dpHl_1ghRPQkP6IF5Vp0iZ8DbA_Rt3JMVhMimZu2wM7Ds/s400/Addins+07.png)
After install process finish, check again in Excel Options window. You will see Analysis Toolpak now below Active Application Add-Ins
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX3BoWmPyA_oNGR1ALqOoWF647k4bNEV2sXWH2S7rE8i8HgUGrOa36XIqyxncYURAExS3Ww_uUTmbxc4nPKderdEdrofqysa9y3SSZOWhMFXaoh_N33IGT5FY5ycHkWPns9pKTOMxiiu4/s400/Addins+08.png)
No comments:
Post a Comment