Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a situation where the calculation takes too long and so I put this in
the ThisWorkbook module "SheetChange" event: ActiveWorkbook.ActiveSheet.Calculate This makes the calculation much faster and I am confident everything is ok becuase all that needed to be calculated was the current sheet but the status bar now reads...: "Ready Calculate" :.... becuase there was not a full calculation done. Are there any good methods of how to handle this. It is more of a communications issue to myself of the status of the calculation in the overall excel system. [Note: I do not want to always be doing a full calculate becuase of the time it takes but, as an additional note, on the BeforePrint event I do have a full calculate becuase I cannot take the chance that something is not fully calculated when printed.] Thank you for your help, Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 calculate time between 2 date/time columns | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Saving a file with time and date at a set time period | Excel Programming | |||
Daylight Saving Time (DST) and calculating time difference. | Excel Programming | |||
Daylight Saving Time (DST) and calculating time difference. | Excel Programming |