Referencing shapes on separate pages

[Daniel Kloberg]

Hi!

In Visio, you can use formulas to retrieve properties from other shapes on a
page. For instance, you can write formulas like Sheet.2!Width, Sheet.4!PinX,
etc in a sheet. My question is this: Is it possible to reference shapes
placed on separate pages in a similar way?

Thanks!
/Daniel

 

[Al Edlund]

I believe it is as simple as prefacing the formula with the page i.e.

Sheet.2!Width
becomes
[page1]!Sheet.2!Width

or something like that
al

 

[Daniel Kloberg]

Hi Al,

I have tested formulas like [page1]!Sheet.2!Width, Page1!Sheet.2!Width, etc
as you suggested but it does not work... Any more ideas?

/Daniel

I believe it is as simple as prefacing the formula with the page i.e.

Sheet.2!Width
becomes
[page1]!Sheet.2!Width

or something like that
al

Hi!

In Visio, you can use formulas to retrieve properties from other shapes on
a
page. For instance, you can write formulas like Sheet.2!Width,
Sheet.4!PinX,
etc in a sheet. My question is this: Is it possible to reference shapes
placed on separate pages in a similar way?

Thanks!
/Daniel

 

[Markus Breugst]

Hi Daniel,

assume you have two pages, named P1 and P2. On page P1 there is a shape
named Sheet.1, and on page P2 there is a shape named Sheet.2.

Go into the ShapeSheet of Sheet.2, and write the following formula into the
PinX cell:
Pages[P1]!Sheet.1!PinX

Now, if you move the shape Sheet.1 horizontally, the shape Sheet.2 will
follow.

Best regards,
Markus

Hi Al,

I have tested formulas like [page1]!Sheet.2!Width, Page1!Sheet.2!Width, etc
as you suggested but it does not work... Any more ideas?

/Daniel

I believe it is as simple as prefacing the formula with the page i.e.

Sheet.2!Width
becomes
[page1]!Sheet.2!Width

or something like that
al

Hi!

In Visio, you can use formulas to retrieve properties from other

shapes

on

 

[Daniel Kloberg]

It worked!!!

Thanks a lot Markus,
/Daniel

Hi Daniel,

assume you have two pages, named P1 and P2. On page P1 there is a shape
named Sheet.1, and on page P2 there is a shape named Sheet.2.

Go into the ShapeSheet of Sheet.2, and write the following formula into the
PinX cell:
Pages[P1]!Sheet.1!PinX

Now, if you move the shape Sheet.1 horizontally, the shape Sheet.2 will
follow.

Best regards,
Markus

Hi Al,

I have tested formulas like [page1]!Sheet.2!Width, Page1!Sheet.2!Width, etc
as you suggested but it does not work... Any more ideas?

/Daniel

I believe it is as simple as prefacing the formula with the page i.e.

Sheet.2!Width
becomes
[page1]!Sheet.2!Width

or something like that
al

Hi!

In Visio, you can use formulas to retrieve properties from other

shapes

on
a
page. For instance, you can write formulas like Sheet.2!Width,
Sheet.4!PinX,
etc in a sheet. My question is this: Is it possible to reference shapes
placed on separate pages in a similar way?

Thanks!
/Daniel