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
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