Excel 2007 recalculating custom function when scrollbar is moved?

  • Thread starter Thread starter ker_01
  • Start date Start date
K

ker_01

I mostly work in 2003, but I'm working on a project to help out a co-worker
who uses 2007. I have two problems (I'll post them separately to keep the
discussion threads clean)

I've written a custom function which is being used to reconcile data across
two worksheets in the same workbook. The function is used in several thousand
cells. There is a lot of data being processed, and it takes several minutes
to update the workbook.

It appears that (in 2007) if she tries to scroll at all (or do much of
anything), it resets the percent calculation to zero. I wouldn't expect the
scroll event to trigger recalculation, since it doesn't actually change any
cells/values... is this expected behavior, and if so, why?

I do turn off calculation at the beginning of the function and turn it back
on at the end; since the function is being used in thousands of cells, I
understand that calculation is being turned off/on that many times...but I'm
still not clear on why a scroll activity would force the recalculation to
start back at 0%.

Thanks for any information,
Keith
 
Any user interaction with Excel during a recalculation interrupts the
calculation.

From http://www.decisionmodels.com/calcsecretsh.htm
You can control the users ability to interrupt calculation by specifying
what will interrupt the calculation.

Application.CalculationInterruptKey= XlAnyKey | XLEscKey | XlNokey

You can also control error handling of the interrupt (in Excel 97 onwards)
using

Application.EnableCancelKey= xlDisabled | xlErrorHandler | xlInterrupt



regards

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
Back
Top