Forum Discussion
Solved
Excel ran out of resources
Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated. Hi Everyone, I'm getting the above error message when opening o...
This error may have something to do with the way the formulas are written. Are you able to share some of your formulas?
The same formulas have been in use for roughly a year. No changes or additions were made when the error started. Do you think it could still be a formula causing the issue? Just not sure where to start, there are many.
Yes. I've seen this error many times. Often the cause of it is using referencing in formulas that points to entire columns.
For example:
=VLOOKUP(A2,Sheet2!A:Z,10,0)It could also be the use of volatile functions (INDIRECT, OFFSET, etc.), excessive formatting, and/or a very large 'usedrange' (When you press Ctrl+End on a sheet, where does it go to?).
Ctrl+End does take me well down each sheet (i.e. row 500 - 1000)
- That's not bad. It would be a concern if you were taken down to the last row.