Hi there,

I have 8 data tables in a complex excel sheet. I've noticed that the more I develop the spreadsheet (i.e. the more I add formulas & sheets), the slower these data tables get (even if the added formulas are unrelated), so two questions:
- How can I optimize the speed of data tables? One of the techniques I use for my other macros is to deactivate screen updating by placing the VBA code before and after the macro itself. But how can I do something similar with data tables? (which are not associated with any VBA / macros, they just run when you click F9)? Are there other technics to speed up calculation?
- I've just noticed that any action by user (even simply clicking anywhere in the sheet) during the calculation of a data table will automatically stop the refresh of data tables. I can't remember if it was always the case in my spreadsheet or if I changed a parameter without noticing but is there a way to prevent users from stopping the refresh? (or at least making it dependent on only 1 or 2 actions, such as pressing the ESC key, not any action)

Thanks!