Installation.

Please close Excel before installing this program.

This Addin was written with MSOffice 2003 but will work with Office 97, Office XP & Later versions also. In case of Office 2000 & 2003, the powerutils1.9.exe will take care of everything.

The Installation Process & how to tackle any problems

1. The Install program will first create a directory as per your choice, copy the required files including install.xla and powerutils.xla. In case you do not have write authority in a specific Drive or directory, the program will stop. In such case select some other drive/directory where you have the authority to write.

2. The Install process then runs install.xla which in turn starts Excel. In case the security setting in Excel is set at High then again Install will stop at this juncture. You have two alternatives. a) You can start excel with a blank sheet, select Tools Options, select Security Tab, select macro security at bottom in security setting select medium and give ok. or b) Select tools .... addins......browse......go to the directory where you have installed Powerutils as per step 1 above, select powerutils.xla and give ok. This will install powerutils.

3. In Step 2 above if you have selected a) ie changed the macro security setting, you need to rerun the exe files. This will overcome the problem in step 2. The install.xla file is opened and it will ask if you can enable macros, select yes. Install.xla will open and take the necessary steps to install powerutils. If the new menu does not come then do step 4.

4. If Powerutils was not installed then open Excel...  Select tools .... addins......browse......go to the directory where you have installed Powerutils as per step 1 above, select powerutils.xla and give ok. This will install powerutils.

In some cases where Powerutils is replacing an older version even after installation the menu is not appearing. In such case select Tools Addins, see if powerutils is there and ticked. If yes then remove the tick and give ok. Now again select tools Addins and tick Powerutils and give okay, the manu will appear.

If you still have a problem then contact me by email with all relevant details & I will help you.

In case any utils are giving any error message please write back along with a image of the error message which you can capture by press <alt> printscreen together.

Prasanta Das Gupta
Wages Section
Finance Division
Tata Motors, Jamshedpur
Pin 831010
India
Phone Office  0657-6693013 
email: prasantad@tatamotors.com
