Excel: Need to Edit Activate Add-Ins Each time I use Them

  • Thread starter WWGD
  • Start date
  • #1
WWGD
Science Advisor
Gold Member
5,419
3,676

Summary:

When I use Excel Add-Ins I must install each time I use.
Hi All,
I am doing a linear regression in Excel 2007. It is not available within the usual settings so I must. Edit: activate , an add-in called (Duh) Edit' Analysis Toolpak'

What seems strange is that I have to install it each time I use it so that it seems to be installed only when the session is open.

Is there a way of installing the add-in permanently so that it is available each time and I don't have to install it each time I use it?


Thanks.
 
Last edited:

Answers and Replies

  • #2
pbuk
Science Advisor
Gold Member
1,904
744
I am doing a linear regression in Excel 2007. It is not available within the usual settings so I must install an add-in called (Duh) 'Data Analysis'.
Are you sure it is called 'Data Analysis'? Linear regression is part of the 'Analysis ToolPak' add-in provided by Microsoft so if you are using an add-in called 'Data Analysis' then it must be from some third party. I can confirm that the Analysis ToolPak add in does stay active between sessions for me on Office 365.
 
  • #3
WWGD
Science Advisor
Gold Member
5,419
3,676
My bad, you're right, it is called 'Analysis ToolPak'. But if I close a session it dissappears and I must reinstall it each time I EDIT open a new session. Is there a way of installing it permamnently so I don't have to reinstall it each time? No major issue, just curious.
 
  • #4
pbuk
Science Advisor
Gold Member
1,904
744
Do you mean 'reinstall', or just 'reactivate'? What version of Excel is this?

EDIT: You already said, it is Office 2007. I can't remember how you used to make add-ins persistent in Office 2007 but it's possible Windows 10 doesn't support it because Office 2007 is end of life.
 
  • Like
Likes WWGD
  • #5
34,545
6,248
Is there a way of installing it permamnently so I don't have to reinstall it each time?
You're running a fairly old version of Excel, so I can't speak to the capabilities of that version as compared to newer versions.

In my version (of Office 2016), one of the dropdowns under the File menu is Options. In the Excel Options pane, the next-to-last item in the pane on the left side is Add-ins. The pane at the right shows Active Application Add-ins, Inactive Application Add-ins, and Disabled Application Add-ins.

If Excel 2007 works anything like the newer versions, I suspect that Analysis Toolpak is either inactive or disabled. If so, select this add-in, and click Go near the bottom of the pane to keep it active from one session to the next.
 
  • Like
Likes WWGD and pbuk
  • #6
WWGD
Science Advisor
Gold Member
5,419
3,676
Do you mean 'reinstall', or just 'reactivate'? What version of Excel is this?

EDIT: You already said, it is Office 2007. I can't remember how you used to make add-ins persistent in Office 2007 but it's possible Windows 10 doesn't support it because Office 2007 is end of life.
It's 2007. I must reactivate it, my bad again, .e., select it as an add-in and reinstall it.
 

Related Threads on Excel: Need to Edit Activate Add-Ins Each time I use Them

Replies
11
Views
916
  • Last Post
Replies
9
Views
4K
  • Last Post
Replies
3
Views
92K
  • Last Post
Replies
8
Views
3K
  • Last Post
Replies
3
Views
23K
Replies
7
Views
1K
Replies
2
Views
943
  • Last Post
Replies
15
Views
314
Replies
2
Views
2K
  • Last Post
Replies
7
Views
3K
Top