Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken Coburn - 28 Dec 2007 11:51 GMT

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.

Signature

Ken Coburn

Reply to this Message

Gord Dibben - 28 Dec 2007 18:16 GMT

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

>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
[quoted text clipped - 4 lines]
>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.

Reply to this Message