I
Iwan van Ee
I have a reference in shapesheet of a shape to a User defined cell in another
pagesheet:
Pages[Rack-4]!ThePage!User.Pagename
That works fine and gives me the name of that page. Now when I change the
name of the page Rack-4 to Rck4 (shorter name). This formula remains
unchanged. But the result of the formula gives me Rck4.
When I try to add a new formula into another Shapes Shapesheet which has a
reference to that page also I normally would insert the formula with the new
pages name:
Pages[Rck4]!ThePage!User.Pagename
This doe not work. I have to use the old name of the page in the formula
which I normally don't know.
How do I have to enter a working formula? I know the function GetRef(),
should I use that one?
This 'error' is also for shapes that have a reference to a cell in another
shape on another page.
I use Visio 2003.
pagesheet:
Pages[Rack-4]!ThePage!User.Pagename
That works fine and gives me the name of that page. Now when I change the
name of the page Rack-4 to Rck4 (shorter name). This formula remains
unchanged. But the result of the formula gives me Rck4.
When I try to add a new formula into another Shapes Shapesheet which has a
reference to that page also I normally would insert the formula with the new
pages name:
Pages[Rck4]!ThePage!User.Pagename
This doe not work. I have to use the old name of the page in the formula
which I normally don't know.
How do I have to enter a working formula? I know the function GetRef(),
should I use that one?
This 'error' is also for shapes that have a reference to a cell in another
shape on another page.
I use Visio 2003.