Results 1 to 5 of 5

Thread: Cannot find solver.xlam

  1. #1
    Join Date
    Oct 2010
    Posts
    76

    Cannot find solver.xlam

    I have installed the Microsoft Office 2007 on my Windows XP machine and there is not problem for running this office softwares on my desktop machine. But when I tried to install the solver add-in then I have got the error as Cannot find solver.xlam where as I have downloaded the one just now. I don't get this issue, How could I solve it and is there some trick to install this Add In on Window XP machine? Please Help!

  2. #2
    Join Date
    Mar 2009
    Posts
    1,360

    Re: Cannot find solver.xlam

    I guess you should try installing the Hotfix which might solve this problem. Though I have not seen any such issue on my Windows XP machine but still I think that this issue must be having its fix in the Hotfix. I suggest you to go the microsoft.com where you must be having a proper Hotfix download for solving this issue. But make sure that you are downloading the proper Hotfix. Here I have got the Hotfix which can solve your issue. If it does not then you may search for the better one which won't be having any such problem.

  3. #3
    Join Date
    May 2008
    Posts
    913

    Re: Cannot find solver.xlam

    To fix this problem yourself, follow these steps:

    1. Click Start, click Run, type regedit in the Open box, and then press ENTER.
    2. Locate the following registry subkey:
    • HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Excel\Options

    3. Double-click the OPEN registry entry.
    4. In the Value data box, delete “/F” from the value, and then click OK.
    5. For example, the OPEN registry key contains the following data:
    • /F C:\Program Files\Microsoft Office\Office12\Library\SOLVER\solver.xlam

    6. Change this to the following:
    • C:\Program Files\Microsoft Office\Office12\Library\SOLVER\solver.xlam

    7. On the File menu, click Exit.

  4. #4
    Join Date
    Nov 2008
    Posts
    1,022

    Re: Cannot find solver.xlam

    Most probably this seems to be the problem with the path of the solver.xlam due to which you it not able to find out the same and hence you are stuck in between the installation process. The solution which has been provided in the above post is the perfect one. You just need to change a little bit in the path which will solve this problem. But make sure that you are not changing any other path as it might become headache to find out the next bug.

  5. #5
    Join Date
    Nov 2008
    Posts
    1,185

    Re: Cannot find solver.xlam

    Solver in Excel 2007 is an add that is not installed by default. If you want to install the same then you have to open MS Excel Options and then in the Supplements, it verifies that the dropdown list. You would be having a Manage at the bottom where you can select for the Excel add-ins and then click on the Go. Make sure that you have checked the Solver supplement in the Add In list.

Similar Threads

  1. Excel Files - Funcres.xla and solver.xla Missing Error
    By Forrest Ranger in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 01:04 PM
  2. I want to use solver in VBA
    By Ulrich in forum MS Office Support
    Replies: 2
    Last Post: 08-02-2012, 03:12 PM
  3. How to use Solver in Excel 2007
    By EricTheRed in forum Tips & Tweaks
    Replies: 1
    Last Post: 18-05-2011, 04:32 AM
  4. LOOKUP.XLAM is already open in Excel 2007
    By Japheth in forum Windows Software
    Replies: 6
    Last Post: 27-05-2010, 05:59 PM
  5. how to share the ribbon with multiple .xlam
    By sezb51 in forum Windows Software
    Replies: 1
    Last Post: 03-07-2009, 02:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •