Hello Everyone,
I have a big table (6K x 64) with multiple calculation fields. It actually has a few sumif functions so it is slow at calculating and I have it set to manual. The issue occurs when a manual calculation (F9) is performed. It will take ~3 sec to recalculate but after that if i want to change a cell (manual input cell) it will take it another 5 seconds or so to just input it, even though it is not performing any calculations, interestingly enough this only happens once, so if i want to change more cells (in the same column) after that they are instant. This seems to be the case for each column. Automatic calculation per cell is roughly 7 seconds, so basically sum of other two calculations. When I convert the table back to regular range it performs way quicker (3 sec per calculation and no input lag). Before I rewrite my VBA code to use ranges rather than the table, has anyone encountered this before?
Thank you.
Bookmarks