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
Thank you Nikolino for your reply, I really do not understand your reply. All I would like to know is how to stop this popping up on my spread sheet,
With the existing Aray formulas in your file, instead of searching through the entire column, you could restrict them to a more restricted area with the formula.
This means that it does not have to calculate all cells in the column (s).
The amount of data is decreasing.
This means that it does not have to calculate all cells in the column (s).
The amount of data is decreasing.
Thank you I have fixed the problem