Trigger a cell to recalculate if anoter cell changes

[novski]

Hi
I have some cells that seam to not calculate correctly until i make any change on the shape (1d Line), as soon  as i move it just a bit it recalculates correctly.
That happens after every re-opening the file.
So i thaugth that i can maybe make a Trigger that makes every shape to recalculate.
But i have to try without Macros because of company security-guidelines.

Does anybody have a idea how i cold start?

Regards, Novski

[Surrogate]

Which version Visio ?

[novski]

Visio 2013 Pro (15.0.4779.1000) 32-bit

[Hey Ken]

Novski:

   Not sure it'll solve your situation, but you can use +DEPENDSON(NOW()) to trigger a recalculation.  There's an example at http://visguy.com/vgforum/index.php?topic=6835.  It triggers a macro call, but it'll trigger any other shapesheet function without macros.  It also triggers the recalculation when you first open the file.

   Good luck!

   - Ken

[novski]

Wow.
That did the Trick and it also helped to solve at another point as well. Thats a Magic wand!
Thanks so mutch!
Regards, Novski

+DEPENDSON(NOW())