Hi,
If I send data to the database with the setting 'manual calculation' in Excel the time is much faster than with 'Automatic calculation'.
My problem is: I need the automatic calculation when the users enter data (because of EV_SUM). Is there an VBA event I can trigger before I send data to the database?
Thanks,
Lars
Edited by: Platon BPC on Sep 9, 2010 12:13 PM