Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 recalculating custom function when scrollbar is moved?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 recalculating custom function when scrollbar is moved?
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 "ker_01" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 function moved to 2007 unable to change absolute references | Excel Worksheet Functions | |||
Excel 2007 - Using a Custom Function to Set Row Color | Excel Programming | |||
Excel 2007 SP1 - How to correct scrollbar extent? | Excel Discussion (Misc queries) | |||
Want to add help file for custom function but excel 2007 is flaked | Excel Worksheet Functions | |||
Excel 2007 is not recalculating formulas when new data is entered | Excel Discussion (Misc queries) |