News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Shapesheet Cell Reference to Shape on Different Page

Started by wxaggie11, February 28, 2011, 07:55:58 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

wxaggie11

I have two shapes "Square.94" and "Square.204" on pages 1 and 2 of the same document, respectively. I have custom shape data called "Name" in Square.94, with the value <SquareA> that I want Square.204 to grab from the user defined cell Prop.Name from Square.94.
(That is to say, whatever Square.94's value is for Name, I want Square.204 to have that same value.)

I entered this code into the Value cell of Square.204, who also contains the shape data called "Name" in it's properties:

=Square.94!Prop.Name

After all this, I keep receiving bad formula. Am I referencing the shape improperly? Am I entering this formula into the wrong cell of Square.204? Or am I referencing the cell improperly?  ???

Visio Guy

Shape ID numbers are unique only to a page, so both pages could feasibly have a Square.94, for example.

To reference shapes on other page, you need additional syntax:

=Pages[Page-1]!Sheet.94!Width

No quotes around the page name, by the way.

Note that =Pages[Page-1]!Square.94!Width will not work. You have to use the "Sheet.ID" notation when crossing pages.

You can read more about ShapeSheet cell references here.

For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

wxaggie11

VisioGuy,

I typed:

=Pages[Page-1]!Sheet.94!Prop.Name

into the Value cell of Square.204 and I'm still getting a bad formula error. Is [Page-1] supposed to be the title of the page? Because if that is the case, this might work:

=Pages[TABLE OF CONTENTS]!Sheet.94!Prop.Name

It seems like it doesn't like my custom shape data...

Jumpy

Two Issues: It could be the Space between the words in the pagename. Try: Table_of_Content or TOC as pagename.
But when changing the name of the page be aware of problem two:

The Pages have a Name and a NameU (= universal name). When you rename a page first time, you change Name and NameU. If you rename the page again, from now on you only change the Name (not the NameU, too). And the NameU is the Name you have to use in ShapeSheet cell references.


wapperdude

If the "code" shown is a literal copy, there should be no space be "!" and "]".  See if that helps.

Wapperdude
Visio 2019 Pro

wxaggie11

Thank you guys for your help! Jumpy, I took your advice and made a completely clean document and I was able to link shapes across pages using that syntax. Thanks a bunch!

Visio Guy

Actually, Pages[table OF CONTENTS]!Sheet.94!Prop.Name should work. The spaces don't seem to matter.
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

Donald

Hello guys,
I'm a Beginner in Visio and I've found this topic where a part of my problem is solved, but...
I've learned here how to work with cross-page references, but it is not working for Master shapes.
What I want to do:
I have a master shape with some shape data and I want to fill one of them with text specified in text box in Page-1 when master shape is dropped on page.
This reference is working if added to the shape on page, now also on other page, but is not working for master shape. It is always lost. I suppose it is about special master page or something, but I can't solve it on my own.
It would save me a lot of work if master shape can absorb some text from the page where it is dropped.

Any idea? Thank you in advance!

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 286 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1163KB.
Tokens: post-login.
Cache hits: 13: 0.00145s for 26,727 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]