J
J. Caplan
I have formula that is used in many of the cells of a worksheet. The formula
hits a database behind the scenes and can be time consuming when run one at a
time. I provide a tool bar button that will gather data from the cells and
do a single DB hit, thus speeding up the process a great deal.
One thing I have noticed, though, is when I delete a row in the worksheet,
Excel goes through and recalculates all cells. I know I can set Calculation
mode to manual before deleting a row, but is there a way to stop this from
happening without setting calculation to Manual?
Is there a way to capture the fact that this is going to happen so that I
can call my routine to cache data first?
hits a database behind the scenes and can be time consuming when run one at a
time. I provide a tool bar button that will gather data from the cells and
do a single DB hit, thus speeding up the process a great deal.
One thing I have noticed, though, is when I delete a row in the worksheet,
Excel goes through and recalculates all cells. I know I can set Calculation
mode to manual before deleting a row, but is there a way to stop this from
happening without setting calculation to Manual?
Is there a way to capture the fact that this is going to happen so that I
can call my routine to cache data first?