Excel 2003

  • Thread starter Thread starter Ken Coburn
  • Start date Start date
K

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.
 
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
 
Back
Top