Excel 2003

[Ken Coburn]

I have created a worksheet that requires the Analysis ToolPak add-in. On one
Windows XP Pro computer, when I close the worksheet and open it again I have
to select the Analysis ToolPak again to allow the worksheet functions to
work. On another Windows XP computer the worksheet opens automatically with
the ToolPak add-in already selected.

How do I get the worksheet to open the Analysis ToolPax automatically on the
first computer so that I do not have to do this manually.

 

[Gord Dibben]

Ken

The selected Add-ins are stored in the Registry under this key.

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

Right-side window see OPEN, OPEN1, OPEN2 etc.

Maybe you do not have permissions to alter the Registry so the ATP does not get
stored.


Gord Dibben MS Excel MVP