Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inter-Connected Worksheet_Calculate events
I was suprised to note that an inter-dependency developed between different
sheets, which do access the same data, but none of which changes that data. For example: Sheet1 and Sheet2 both access data on Sheet3. Neither Sheet1 or Sheet2 modifies the data on Sheet3. However the simple act of entering new data in Sheet1, which causes Sheet1 to access data on Sheet3 (without changing Sheet3), forces a "Worksheet_Calculate" event on Sheet2 - the reverse is also true, any change on Sheet2 forces a "Worksheet_Calculate" event on Sheet1. I would have expected the "Worksheet_Calculate" events of Sheets1 and 2 to remain independent. Notes: The "Worksheet_Calculate" event for Sheet3 does not occur. Sheets 1 & 2 utilize the "Today()" function Sheet2 has a Chart who's source data is on the same sheet. Sheets 1 & 2 utilize UDF's, but they do not share any UDF's, nor do the UDF's affect any changes to any common source data. Does anyone have any comment as to whether this inter-dependency between Sheet1 and Sheet2 is normal? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inter-Connected Worksheet_Calculate events
For anyone who may read this - the problem was the function "Today()".
"mickey" wrote: I was suprised to note that an inter-dependency developed between different sheets, which do access the same data, but none of which changes that data. For example: Sheet1 and Sheet2 both access data on Sheet3. Neither Sheet1 or Sheet2 modifies the data on Sheet3. However the simple act of entering new data in Sheet1, which causes Sheet1 to access data on Sheet3 (without changing Sheet3), forces a "Worksheet_Calculate" event on Sheet2 - the reverse is also true, any change on Sheet2 forces a "Worksheet_Calculate" event on Sheet1. I would have expected the "Worksheet_Calculate" events of Sheets1 and 2 to remain independent. Notes: The "Worksheet_Calculate" event for Sheet3 does not occur. Sheets 1 & 2 utilize the "Today()" function Sheet2 has a Chart who's source data is on the same sheet. Sheets 1 & 2 utilize UDF's, but they do not share any UDF's, nor do the UDF's affect any changes to any common source data. Does anyone have any comment as to whether this inter-dependency between Sheet1 and Sheet2 is normal? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inter-dependency | Excel Worksheet Functions | |||
worksheet_calculate | Excel Discussion (Misc queries) | |||
Worksheet_calculate() | Excel Programming | |||
[email protected] | Excel Discussion (Misc queries) | |||
worksheet_calculate **help** | Excel Programming |