Excel 2004 "Losing" loaded Addins

[Kristina]

I generally keep a couple of the addins that ship with Excel loaded
(Analysis Toolpack, Internet Assistant VBA). I also have about 6
custom addins loaded. In Excel 2004, I have found that both kinds of
addins don't stay loaded from session to session. Meaning, they're
not appearing in the Project Explorer in the VBE, and are not active,
even though they are checked off in the Tools: Addins dialog box.

I've been working with someone at Microsoft on this problem for over a
week, but I'm getting nowhere. They did identify a bug involving the
Analysis Toolpack (it loads by itself, even though you don't have it
checked off), but that seems to be a separate issue. I've tried
trashing Prefs and the plist, but that doesn't help, either.

I can consistently reproduce the disappearing addins trick on both of
my machines. Both are running OS 10.3.4. One has Office 98, X and
2004 installed. The second has only Office 98 and 2004. Both are
dual-boot systems. In all cases, each app has it's own Addins folder
(created automatically during the install). I'm only running one
version of Excel at a time. Another user has also experienced this
problem on a third machine. I've never seen this problem with any
other version of Excel (mac or windows).

Has anyone else experienced this problem? Have you found a solution?

Kristina

 

[Jim Gordon MVP]

Hi Kristina,

I'm assuming that you've already run Disk Utility to repair permissions.
Have you run DiskWarrior to make sure the OS file structure is OK?

-Jim

 

[Kristina]

Hi Jim,

No, I haven't tried either of those suggestions, as I'm seeing the
problem on multiple machines (and now MS can reproduce it, too), but
I'll give it a shot.

Thanks,

Kristina

 

[Kristina]

Thanks for the suggestions, Jim, but I didn't have any better luck
after running those tools. The addins still disappear.

Kristina