ShapeText across pages

[mikashharia]

Hi,

I use =SHAPETEXT(Sheet.346!TheText) to display the text of a shape on another shape. is it possible to do this across pages.
i.e set the text on page 1 but show the same text on a shape that is on page 2.

thank you

Mikash

[wapperdude]

Yes.  Use the formula: Pages[Pagename]!Shapename!TheText.


For a complete list of Shapesheet formulas, see this link:http://msdn.microsoft.com/en-us/library/aa200961(office.10).aspx#572


Wapperdude

[mikashharia]

Thank you.

I tried what you suggested (=Pages[Client landing mobile 1]!Sheet.291!TheText) but the text displayed on the second page is 0 rather then the actual text i entered on page 1.

am i doing something wrong?

[wapperdude]

Sorry. 

Left out part of the formula necessary for shape text.  The entire formula should be something like:
=SHAPETEXT(Pages[2nd Page]!Sheet.1!TheText) where I named Page-2 to be 2nd Page.

[mikashharia]

I tried what you mentioned and got the error below. please advise.

[Surrogate]

Then you add page in document visio automatically named this page Page-4 (for example). If you renamed this page to 4st.
Formula

=SHAPETEXT(Pages[4st]!Sheet.1!TheText)

still right!
But when you one more time renamed page to 4

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

wrong formula

=SHAPETEXT(Pages[4st]!Sheet.1!TheText)

right formula

sorry for my English.

[mikashharia]

Ok thank you

So if i rename a page more than once the formula will not work?

[Surrogate]

all early inserted formulas still usefull. but when you need add new field, you must use real page name (.NameU), not as you can see at bottom of visio application window.

http://msdn.microsoft.com/en-us/library/ff768469(v=office.14).aspx
but i don't know how find NameU, if don't use VBA

[Paul Herber]

but i don't know how find NameU, if don't use VBA

My Visio Super Utilities
http://www.sandrila.co.uk/visio-utilities/
SuperUtils -> Page -> Page Report

[mikashharia]

Ahh cool understand now. i have to use the original name in the formula before changing the page name.