Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2002
    Location
    Melbourne, Victoria, Australia
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Solver error (office 97)

    When the solver option is clicked i get the following error;

    The file could not be accessed try one of the following;

    Make sure the folder exists
    Make sure the folder that contains the file is not read only
    Make sure the filename does not contain any of the following characters <> ? [ ] : or *
    Make sure the file/path name doesnt contain more than 218 characters

    I have checked all of these suggestions and can find nothing wrong.

    Any ideas??

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel Solver error (office 97)

    You need to check that Solver.xla and Solver32.dll are available to excel. They are installed by default in ...Microsoft OfficeOfficeLibrarySolver, so if they are not in place you need to run Excel setup and install the add-in.

    Andrew C

  3. #3
    Lounger
    Join Date
    Jul 2002
    Location
    Melbourne, Victoria, Australia
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Solver error (office 97)

    Thanks that worked. I copied the necessary files an d it is now ok.

Posting Permissions

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