Excel 2007 recalculating custom function when scrollbar is moved?

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
 
C

Charles Williams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top