You must follow each step in the exact sequence to install KATE successfully:
Make sure your Excel is ready to run VBA and AddIns (you must have Analysis Toolpack and Analysis Toolpack – VBA)
If your Excel is in any language other than English, please pay attention to the extra step at the end of the installation tutorial. If your Excel uses file names in Chinese, read the special instructions here.
Download and extract Kamakura Analytics Install.zip into a folder (PickAnyName) in your local drive
Add the new folder (PickAnyName) and its subfolder to the Trusted Locations in the Microsoft Excel Trust Center <= Critical Step!
Find the file named Kamakura Analytic Tools 2010.xlam in the AddIns subfolder under your new folder (PickAnyName)
Right-click on it to check its Properties.
If you see an option to Unblock in Attributes, put a check-mark to do it.
This file must be unblocked before you use KATE. <= Critical Step!
Run Install Kamakura Analytic Tools.xlsm and select the tools you want to install.
You must keep the new folder (PickAnyName) and its subfolder (AddIns) until you no longer want to use KATE and want to uninstall it (as shown below).
You will find the following files and folder:
Install Kamakura Analytic Tools.xlsm - a macro to install KATE
Kamakura Analytic Examples.xlsx – a worksheet with one data sample for each tool available in KATE
Read Me.pdf – a brief description of KATE
AddIns – a subfolder containing all the macros and libraries used by KATE. You must keep this subfolder and the main folder until you decide to uninstall KATE
Uninstall Kamakura Analytic Tools.xlsm – a macro to uninstall KATE. You should only delete the folder and subfolder containing KATE files after running this macro.
If you find KATE useful, please tell your friends! If not, please let me know why