Forum Discussion
Solved
excell
I keep getting this message when working on one of my worksheets ( excel ran out of resources while attempting to calculate one or more formula, as a result, this formula cannot be evaluated ) E...
- That is great , It has solved my problem thank you for your help
I was facing a similar problem where there were a few array formulas down about 150.
The reason is most likely that when the computer tries to process the large amounts of data, it uses multithreaded calculations. When multi-threaded calculation is turned to off, the computer doesn't throw the 'Excel ran out of resources...' error.
Thus to turn off multi-threaded calculation, follow the steps below:
• Navigate to the 'File' tab in your Excel sheet and select “Options”.
• On the right side select “Advanced” and scroll down to the heading “Formulas”.
• You will see a check box that says Enable multi-threaded calculation. Untick it, then select 'OK' and recalculate your formulas.
I hope this helps!
Other than this, if you face any kind of .xls or .xlsx file corruption in Excel you can check out this reference [https://social.technet.microsoft.com/Forums/Lync/en-US/e5692c4a-924d-44a5-985b-7878f3eb26de/corrupted-excel-file-repair?forum=excel]
The reason is most likely that when the computer tries to process the large amounts of data, it uses multithreaded calculations. When multi-threaded calculation is turned to off, the computer doesn't throw the 'Excel ran out of resources...' error.
Thus to turn off multi-threaded calculation, follow the steps below:
• Navigate to the 'File' tab in your Excel sheet and select “Options”.
• On the right side select “Advanced” and scroll down to the heading “Formulas”.
• You will see a check box that says Enable multi-threaded calculation. Untick it, then select 'OK' and recalculate your formulas.
I hope this helps!
Other than this, if you face any kind of .xls or .xlsx file corruption in Excel you can check out this reference [https://social.technet.microsoft.com/Forums/Lync/en-US/e5692c4a-924d-44a5-985b-7878f3eb26de/corrupted-excel-file-repair?forum=excel]
- That is great , It has solved my problem thank you for your help