Analysis/Solver install problem

Question

Trying to use the Analysis and Solver add-ins. By selecting File/Options/Add-ins/Manage../Go then ticking "analysis", the Analysis add-in moves from the 'inactive' to the 'active' list but doesn't then appear in the Data tab. If I tick "solver" I get an error box telling me that it cannot access the solver.xlam file (and the Solver add-in stays in the inactive list). The xlam file does exist in the right location. Trying to add other add-ins gives the same result. Nothing added-in!

I saw one suggestion of an add-in installer bug. My %windows% folder is not "C:\WINDOWS" but C:\WINDOW2. However a registry search for the wrong CLSIDs didn't find anything.

Peter

Answer 1

I HAD this problem. 

The problem was not installing 'Visual Basic for Applications' before, when I installed Office 2007.

VBA is in Office Shared Features group.

Just insert your Office installation disk, select 'Add or Remove Features' and then VBA.

Should be Office Shared Features > Visual Basic for Applications (MAKE SURE THIS IS SET TO "RUN FROM MY COMPUTER"

After that Solver and Data analysis can be installed in Excel.

Good luck.

Answer 2

Hi bwmoore:

Many thanks for your suggestion. I tried it, creating a new admin user, changing to that, then trying to install the Analysis and Solver addins there.  Still the same problem - the Analysis addin moves from the 'inactive' to the 'active' addin list but is nowhere to be found. I assume it shows as an icon in the 'Data' tab on the Ribbon but I can't find it. Trying to add-in the Solver gives me the error message that the SOLVER.XLAM file cannot be accessed (see my posting of Feb 23).  The rest of Excel works fine for me, but I wish I had kept the earlier version and not upgraded to Excel 2010.

Peter

Answer 3

I had the same problem that you describe when installing the solver add-in.  I subsequently started having a problem where Excel would crash whenever I tried to type into a cell.

For that problem, I found a case where the cause was a corrupted user profile and the solution was to backup all files under the user ID, create a new user ID with admin authority and restore the files to the new admin user.  There were some additional instructions for going back to the original user ID, and how to deal with a new user ID token (I'm sure that isn't the correct term).  I can't find that case at the moment...sorry.

In any case, after I fixed the problem with the corrupted user profile, I was able to install the solver add-in without incident.

This was an unbelievably obscure and painful solution to two problems that should not have occurred in the first place.  Fortunately, this was a brand new machine and there weren't any user files other than some downloaded utilities.  If the machine had been a little older with more user files, I would be apoplectic.

Answer 4

Nayana:

I did say, on May 11, "I have (of course) tried repairing Office many times" after your reply on Feb 23rd. This doesn't fix the problem. See my post of Feb 23rd.with the details. I did not see any further reply from you after that so the problem is still unsolved.

Peter.

Answer 5

Try to repair Office and verify the status. To do click on start > Control Panel > Add/Remove programs > Select the Office 2010 suite installed > click on change > Repair > Continue.