B
BKO
Hello,
I have a large data file (10.000 rows / 10 columns) from wich I have to
process data. I use a lot of index match formula's, lookup tables and data
validations, in multiple sheets
Now the calculation of the sheet takes about 25 seconds after each input.
How can I speed up the calculation time, or calculate only the cells that
are actualy changed after input.
Any help or information about this matter would be appreciated very much,
Thanks in advance
I have a large data file (10.000 rows / 10 columns) from wich I have to
process data. I use a lot of index match formula's, lookup tables and data
validations, in multiple sheets
Now the calculation of the sheet takes about 25 seconds after each input.
How can I speed up the calculation time, or calculate only the cells that
are actualy changed after input.
Any help or information about this matter would be appreciated very much,
Thanks in advance