I would appreciate help with this problem of Excel reporting that it has run out of resources and so cannot evaluate my formulas.
I thought it may have been that the spreadsheet was too busy, so I copied just the first sheet and removed as much of the non-required info, (reducing from 23MB to 7.3MB) but still the problem remains. I have removed the conditional formatting.
I am running Excel 2013, W8.1, in a 16GB RAM, i7-4800MQ at 2.7GHz, so I cannot fathom what limitation I am hitting.
In the attached spreadsheet, the troublesome formulas are in B2802 - B2854, & C2802 - C2854. The problem first came up when I copied across from the B col to the C col.
I tried to get a link to my OneDrive, but I'm afraid it defeated me. I hope this link with MediaFire will do.
http://www.mediafire.com/view/lenac2..._20150409.xlsm
Bookmarks