Monday, July 16, 2012

How to Add an Analysis Toolpack in Excel 2003 GPO


1. Launch Excel 2003. To install the Analysis Toolpak on a version of Excel that was installed through a GPO (Group Policy Organization), you need a privileged account, or you must talk to your network administrator to unlock the procedure.
2. Click on the 'Tools' menu item. Navigate through the drop-down menu and select 'Add-Ins'. A dialog box will appear; this will show all the add-ons currently available.
3. Check the check box that says 'Analysis Toolpak.' You may need to click on the 'Browse' button to load it; it will be listed as Analysis.xla in the Add Ons folder for Excel. If you do not see it, you may need to reinstall Excel 2003 from your installation media. If prompted 'Do you want to install the Analysis Toolpak?', click 'Yes' to install it.
4. Click the 'Tools' menu item; there will now be a 'Data Analysis' entry added to the drop-down menu.

Blogger news