Missing Project or Reference - Obvious solution not working

[Cindy Ellis]

Hello all,
Im trying to help a co-worker with a stubborn "missing reference" problem. We're both running Excel 2007 on Windows XP, corporate controlled environment, so we should be set up nearly the same with regard to software versions. She is attempting to run a macro I've written, but she gets a "project or library missing" error. Looking at the references within VBE, the reference to atpvbaen.xls indicates it's missing, so that seems the logical problem to solve.
I've stepped her through the process of finding the file on her system (C:\windows\program files\Microsoft Office\Office 12\library\Analysis\atpvbaen.xlam), and she can double click or highlight and click OPEN, but the reference is still tagged as missing in the Tools References dialog. As a point of reference, the atpvbaen.xls reference does use the .xlam extension in Office 2007.
We've tried at least 5 times without success.
Her macro settings are set to "enable", "Trust the VBA Project object model" is checked...any ideas on why this won't work?
Thanks for any help,
Cindy

 

[jmthompson]

Know very little about this, but it sounds like atpvbaen.xls really is missing, only atpvbaen.xlam is available. Can you change the reference?

 

[Andrew Poulsom]

Can't you just uncheck the reference to atbvbaen.xls, then install the Analysis ToolPak - VBA Add-In and set a reference to that?

 

[Cindy Ellis]

Andrew...you may have hit on something there. I assumbed that if the file was available in the specified location (which it is) that selecting the reference would be adequate.
I presume this is through the Add-Ins manager from Excel Options. Funny, mine showed as inactive (the same as hers), but I was still able to run the macro. Weird.
I'll let you know if that solves her problem.
Cindy

 

[Cindy Ellis]

Thanks Andrew...problem solved.
I had completely forgotten that the Toolpak had to be installed through the add-in manager.
(She was also amazed that I could get an answer from a forum so quickly...she thought it would a couple of days at best.) Little does she know the power of the MrExcel Forum!