Solver crashes Excel

[Chris]

I am trying to use the "Solver" function in Excel, but it keeps crashing
on me. If I try to pull it up from a file that someone sent me from Excel
on Windows, it crashes instantly. If I copy and paste the data to a new
spreadsheet, it'll let me complete setting up the analysis, but then
crashes when I click solve.

Does anyone else have this problem?

Chris.

 

[Michael R Middleton]

Chris -

I am trying to use the "Solver" function in Excel, but it keeps crashing

on me. If I try to pull it up from a file that someone sent me from Excel on
Windows, it crashes instantly. If I copy and paste the data to a new
spreadsheet, it'll let me complete setting up the analysis, but then crashes
when I click solve.
Does anyone else have this problem? <

Operating system version?

Excel version?

Updates?

Etc?

- Mike

 

[Bob]

I am having the identical problem on my new G4 laptop,
running OS X (version 10.3). I purchased Office for Students
and Teachers (or something like this) separately, deleted the
Test Run Office, installed Office, and then Solver using Add-ons.

Any ideas how to correct this?

Bob

 

[J.E. McGimpsey]

I am having the identical problem on my new G4 laptop,
running OS X (version 10.3). I purchased Office for Students
and Teachers (or something like this) separately, deleted the
Test Run Office, installed Office, and then Solver using Add-ons.

Any ideas how to correct this?

First, did you delete Office Test Run using the Remove Office
application (found in the Value Pack folder in your Office install
CD)? If not, run that app, removing Office, then reinstall.

Make sure you install Solver *before* running any updaters - if
you've updated Office, then install anything from the Vaue pack, you
need to run the updaters again.

Make sure you've applied updates 10.1.2, 10.1.4, and 10.1.5, found at

MacTopia Downloads:
http://www.microsoft.com/mac/downloads.aspx

Finally, repair disk permissions:

Run the Disk Utility (in the ./Applications/Utilities folder). From
the First Aid tab, click "Repair Disk Permissions".

This should clean up your problems - post back if it doesn't.

Note: The Students and Teachers version of Office is identical to
the Standard Office version - the only difference is the terms of
the license, the price, and the packaging.