Fake Off-Page reference

[Hendershot]

I'd like to have a shape that I create behave like an Off-Page Reference
shape by displaying the text contained in a shape from another page. I should
be able to do it by inserting a field, but I can't figure out how to
reference the shape from another page... any suggestions?

 

[Hendershot]

The formula that I use to do this on the same page is:

=SHAPETEXT(Sheet.1!TheText)

I tried referencing another page using the below formula but get an error
saying "Error in formula."

=SHAPETEXT(Page-1/Sheet.1!TheText)

 

[John Goldsmith]

Hi there,

You're almost there. Change your formula to:

=SHAPETEXT(Pages[Page-1]!Sheet.1!TheText)

Best regards

John


John Goldsmith
www.visualSignals.co.uk

 

[Hendershot]

That worked perfectly. Thanks John!

 

[Mark Nelson [MS]]

Why fake it when you can get the real functionality?
http://blogs.msdn.com/visio/archive/2006/06/27/647570.aspx

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.