E
Ergun
Problem definition: I have few objects connected to each
other and some of the shape sheet cells are cross-
referenced such that at the end it becomes a circular
reference such as :
object1's cell A= Sheet.2!Prop.cellA,
object2's cell A= Sheet.3!Prop.cellA
object3's cell A= Sheet.1!Prop.cellA
When the circular reference occurs, Visio 2002 calculates
the loop few times and comes back. My problem is that when
there are large number object in the loop, Visio slows-
down drastically. I cannot avoid not having the circular
reference.
Question: How can I turn on/off auto calculation in the
cells or limit the number of times it recalculates? I need
to have auto calculation but not all the time.
Cheers
Ergun
other and some of the shape sheet cells are cross-
referenced such that at the end it becomes a circular
reference such as :
object1's cell A= Sheet.2!Prop.cellA,
object2's cell A= Sheet.3!Prop.cellA
object3's cell A= Sheet.1!Prop.cellA
When the circular reference occurs, Visio 2002 calculates
the loop few times and comes back. My problem is that when
there are large number object in the loop, Visio slows-
down drastically. I cannot avoid not having the circular
reference.
Question: How can I turn on/off auto calculation in the
cells or limit the number of times it recalculates? I need
to have auto calculation but not all the time.
Cheers
Ergun