The resources problems in Excel are well known and documented. The cause unfortunately is not so easy to pinpoint depending on the various combinations of features which are being used. One simple thing worth trying is to set the formula recalculations to manual to avoid the possibility of entering into a very long chain of events each time a change is made.