Solver unexpected internal error

Nuz

Board Regular
Joined
Aug 16, 2010
Messages
88
I have an Excel application which uses Solver through VBA looping to solve around 20-25 problems each time the VBA code is run.
I run this application in Excel 2010 (32-bit) and Win7.

I am now receiving a message "Solver: An unexpected internal error occurred, or available memory was exhausted" when I run the application on my desktop computer. (I have run the same application in history with the exact same data without that problem).

I tried the same application on my laptop (32-bit Excel and Win7 there too) and there I didn't receive that message. My laptop computer processor has 2.2 GHz but my desktop has 2.67 GHz. Both have 4GB RAM. No other Excel workbooks are open.

How is it possible that the application works on one computer but not on another computer with similar system?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
I have the same problem, two workstations but not the laptop, Excel 2010, and from dialog, not from VBA.

Regards,
Allen
 
Upvote 0

Forum statistics

Threads
1,214,620
Messages
6,120,559
Members
448,970
Latest member
kennimack

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top