Fake Off-Page reference

H

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?
 
H

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)
 
Top