Excel - Long Lag on Data Entry

Subodh_Tiwari_sktneer Thanks for your reply. I have saved as binary file and double-checked all used ranges. My formulas are very simple, and do not use sumifs, etc or refer to whole columns or rows. The 2nd thru 4th sheets are tables of helper columns, simple calcs. The 5th thru 7th sheets are essentially cartesian products of tables in 2~4 referencing those helper cells directly. I did all matrix lookups in vba and hardcoded the appropriate cell references in these larger tables 5~7. 

So I don't believe calculations are the issue. After whatever is happening on data entry is done and I can again control movement to another cell, the calculations themselves take only a few seconds. Given the complexity of the application I find that acceptable. I have essentially built this is access as well, with the caresian product tables already defined. The queries to join these tables with 'helper' tables providing data for calculations, which in this case must be done by the query, are much slower than can be done in excel.

It's really only the data entry lag that has me concerned. Best debugging clue I can provide is that 1st entry after a full recalc will lag. I can then do multiple additional entries without issue. BUT, if I instead delete the value in the cell I'd just entered, I will experience the lag again.

The workbook is large but formulas are not complex and books calcs quickly. There is something else causing this lag I believe.