Microsoft Excel unexpected internal error occurred

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.

• Status: Open
• Question Views: 3044
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Dirk Peterson

Go To Solution

Best Answer

Best Answer

Answered By Dirk Peterson 0 points N/A #97920

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.

About Dirk Peterson

Questions
0

Answers
4

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/04/2011
• Question Category: MS Excel

Answered By Sharath Reddy 590495 points N/A #97921

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.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 05/19/2012
• Question Category: MS Excel