Pages in Fields in 2010

Started by jimdoria, April 30, 2012, 03:24:54 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jimdoria

I just started using Visio 2010 and I'm doing something I'm FAIRLY sure used to work OK, but now is not.

Very simple really - I want to re-use the text from a shape on a background page in multiple places on a foreground page.

If the background page is named "Back" I'd expect this to work as the field that would insert the text from Sheet.2 on that page:


=SHAPETEXT(Pages[Back]!Sheet.2!TheText)


But I keep getting error in formula. I've tried putting "Back" in single quotes and even just using an index (i.e. Pages[2] even though that's not the page I want.).

Nothing using Pages seems to work - I just keep getting "error in formula".

Am I referencing this the wrong away?

JohnGoldsmith

Have you renamed the background page at all?  There's a difference between the local and universal names for objects in Visio.

You can use the BKPAGENAME function to check this by passing in a language ID of 750, for example:

=BKPAGENAME(750)

This should return the universal name of a page's background page.

Type this into a spare user cell and toggle between formula and value to see what the NameU (universal name) is and then use that string in your 'Pages' syntax.

Hope that helps.

Best regards

John
John Goldsmith - Visio MVP
http://visualsignals.typepad.co.uk/