Make Timer function more efficient

**mat83400** · 09-05-2016, 08:28 AM

I am running a macro every time increment I want, can change that increment in B1.

My problem is that I run this on a workbook with LOTS of calculations that take place every second and every time my macro runs after it is called by the timer, excel struggles and takes a couple of seconds to calculate. If I turn off automatic calculation for the full workbook, everything works fine! But I CANNOT turn it off permanently because I still need all of these other calculations to run in the meantime.
I tried to use Application.Calculation = xlManual & Application.Calculation = xlAutomatic at the beginning and the end of macro1 but it would not change anything. I know it's coming from the start1 macro but I am not sure how to tweak it to make it work. Basically I think I need to change to Manual calc every time I reach the time increment and change back to Automatic right after...

Please Login or Register  to view this content.

**AlphaFrog** · 09-05-2016, 09:20 AM

Whenever you resume automatic calculations, Excel will recalculate formulas that need recalculating.
What are you using the incremented value in C1 for?
Are your formulas using the incremented value in C1?

Spit-balling:
You can set just a sheet to manually calculate instead of the whole workbook. Don't know if that would help.

Please Login or Register  to view this content.

Or you could have the macro increment a value and display it in the status bar or on a userform instead of a cell. Or increment a variable but only write it to the cell when you click a button or something.