Fix a 3 second delay when entering text in any cell

[lightmaster]

I have a fairly large workbook (60+sheets) that I'm taking over maintaining. Its got a lot of macros in it that control moving data from entry sheets into databases, and collecting that data into report sheets. I've been successful speeding up several sheets that had macros that took 30+ seconds to complete and have gotten them down to 2-3 seconds, but for some reason whenever you enter data into any cell on any sheet, even a brand new sheet that's not referenced by anything else, there's a 2-3 second delay before excel allows you to do anything else. What are some things that I could look for that could be causing this lag, especially when you make a new sheet?

 

[lightmaster]

I might go back and make them recalculate only when the workbook opens, but as of now there are no more TODAY() functions in the entire workbook and I can't tell any input lag when entering data. I guess most of the input lag was from 1000s of TODAY() functions updating.

 

[wideboydixon]

Cool. Nice job.

WBD

 

[lightmaster]

Thanks for all the help!