Loading / Unloading Add-ins mystery

[SIGE]

Hi All,

I've some weird behaviour with my Add-inns ...

(Working with Ecel 97 SR2)

When checking the standard Add-ins available:
eg.
Analysis Toolpak,
Analysis Toolpak - VBA
They will get loaded.

Upon closing and re-opening my excel-application...
They get unloaded both... meaning that they are not checked anymore in
teh Add-In manager(Tools-Add-Ins...).
Or: one is checked and the other unchecked. And randomly. One time the
A.Toolpak checked and AT VBA unchecked, or vice versa.

On top of it,
Even if teh Analysis Toolpak is checked ...and I go to the VBE-editor.
I do not see the funcres.xla ..I have to uncheck it and check it again
before it loads!
Or when the TA VBA is checked ... no atvbaen.xla to be seen!

Same story for ALL my add-ins ... (the standard Microsoft ADD-INs)
BASICALLY: when they are checked ...and you close excel..upon opening
some are checked others not. But one things they have in common:
Checked or not they are not in my VBE!!!

Sigh sigh sigh
Sige

 

[SIGE]

ANY wizard around with (a) possible cause(s)? ...

 

[Tony]

This thread seems to have gone cold - sorry, it seems like
a tough one. I'm definitely no wizard, but do you have an
AddIn that may be tampering with the others, e.g.,
flipping the AddIn flag? Just a thought.

Tony

 

[SIGE]

Hi Tony,

I found the "problem" a while ago now ... better share what was wrong.

=> No Add-ins conflicting but: a "Command-Line Switch"-issue
(right-click your Excel-icon=>Properties=>Target: from this location
your Excel starts up ...putting: "/automation", or "/s" After this
address forces your excel to start as a "clean-boot", "safe" start-up
BUT consequently does not load any ADD-in or files in the Xlstart
folder!!!

That's what it did ...more or less...:
Being on a network environment ... excel always starts-up via a file
of our Software-supplier ... this one causes my "clean-boot"
start-up... knowing that there are about 30.000 employees in my firm:
quite impressive to "un-load" from all of them every Add-in ...
(this being said, I did not see teh command line switches
"/automation" or "/s" in that famous start-up file .. but there is so
much code in it, that i didnot bother to check...)
Solution: direct short-cut on the excel.exe ..and start your excel
always via this shortcut ..and problem solved
)
Sige