Asked By
peterpond
0 points
N/A
Posted on - 08/04/2011
Hi guys,
I am posting here an error message that I encountered. I met this error when I am about to open a Microsoft Excel file sent to me via email attachment.
Microsoft Excel
Solver: An unexpected internal error occurred, or available memory was exhausted.
OK
The error message above gives a lot of headache to me because I need to open the file sent to me. All that was said on that error I already checked. I have a lot of hard drive space and my memory is above the requirements for Microsoft Excel.
I already scanned the file for some virus attack but no virus was found. Please share some ideas on how can I open this file. Thanks a lot.
Microsoft Excel unexpected internal error occurred
Try to add the following code before you call any solver functions and see if it solves the problem:
Application.Run "Solver.xla!MenuUpdate"
If this does not work try using:
Application.Run "Solver.xla!Auto_Open"
If still no luck this last one should work:-
1. Move both decision variables so that they are next to each other
(Example: – Putting them in C6 and C7.)
2. By Change changes this option of Solver Ok to reference the decision variables cells using Range option.
Hope this will solve your problem.
Thanks.
Microsoft Excel unexpected internal error occurred
If you also have other opened applications besides Microsoft Excel, try closing them all and leave only Microsoft Excel running. Try opening the file again. If this doesn’t work, restart your computer then try opening the file again.
After booting Windows, don’t open any other programs besides the Excel file. If this still doesn’t work, try opening the file on a different computer. This will determine if the problem is with the file or with the application in your computer.
If the file successfully opened on the other machine, try uninstalling Microsoft Excel from your machine then check your computer for any possible errors. Use a disk utility application to check the system. After that, install the application again. Try opening the file afterwards.
