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?
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?