I run service calls on customer equipment.

I have a DB of all the equipment (address, unit #, serial, config, etc.). It also has an area to accumulate call data (date, call number, unit serviced, travel and work start/stop times).

I have an autorun main menu, where I can AED (Add, Edit, Delete) either machine information and call data. It does a lot more too.

I enter the call data at the end of the week, so I am doing 20-30 calls. When I exit out of entering the call data, it can take up to five minutes for Excel to catch up and show the updated metrics as it completes all the loops and calls I have accumulated.

Is there a way to run functions multiple times without accumulating such a backlog?

Is there a setting so that the autorun activates at the exit of any function?