Excel error "Ran out of Resources"

[Eurekaonide]

Hi All

I have a workbook which is quite heavy in formulas and not VBA and Im now getting the error message Excel ran out of resources to perform the calculation and the formuilas are not working.

Does anyone have a fix for this?

I have reduced down the data as much as I can and the formulas. There are 4 Pivots not terribly big mind.

My only other thought is Im using the formula =LOOKUP(2,1/(('Baseline_Data (2)'!$A:$A=HOME!$B$12)*('Baseline_Data (2)'!$B:$B=HOME!E20)),'Baseline_Data (2)'!$C:$C)

like this quite a lot and I wonder if this is the issue?

Thanks

 

[Joe4]

It may help if you can replace the entire column references with defined ranges, i.e.
instead of using references like this:

$A:$A

narrow it down to only look at al the rows you may use, i.e.

$A1:$A1000

Just be sure to pick some row number you will never exceed.
Do this to ALL the complete column references.

 

[Eurekaonide]

It may help if you can replace the entire column references with defined ranges, i.e.
instead of using references like this:

$A:$A

narrow it down to only look at al the rows you may use, i.e.

$A1:$A1000

Just be sure to pick some row number you will never exceed.
Do this to ALL the complete column references.

Thank you so much I believe this has resolved the issue

 

[Joe4]

Excellent! Glad to hear it!
Thanks for letting us know.

Yes, certain formulas, like the LOOKUP formulas, can be expensice/use a lot of resources, so it is best to minimize them to just look at the appropriate ranges and not the entire column, whenever possible.