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

  • Thread starter WWGD
  • Start date
  • #1
WWGD
Science Advisor
Gold Member
2019 Award
5,122
2,321

Summary:

When I use Excel Add-Ins I must install each time I use.

Main Question or Discussion Point

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,235
262
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
2019 Award
5,122
2,321
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,235
262
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.
 
  • #5
33,079
4,782
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.
 
  • #6
WWGD
Science Advisor
Gold Member
2019 Award
5,122
2,321
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 for: Excel: Need to Edit Activate Add-Ins Each time I use Them

Replies
11
Views
261
  • Last Post
Replies
9
Views
4K
  • Last Post
Replies
3
Views
91K
  • Last Post
Replies
3
Views
23K
  • Last Post
Replies
8
Views
3K
Replies
2
Views
836
Replies
2
Views
2K
Top