Insert cell reference from a different page

Started by Sonartech, August 04, 2009, 01:45:14 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Sonartech

I am trying to insert a cell reference from the custom properties of a shape on one page into another page.

I have a shape on Page-4 (a background page) that has custom properties set. I want to show one of those properties on Page-5 (another background page).

The Shape ID = 19 and the property I want to display is called Prop.Project

I tried the following:
On Page-4, select the object to show the custom property and then select Insert|Field and then enter the following Custom Formula:
=Pages[Page-4]!Shape.19.Prop.Project

The result gives me a Error in formula message.

I have tried to display various properties from Page-4 without success, so I am wondering if I am using bad syntax for referencing the other page.

Thanks

DavidJT

This is an old post but other may look for answers in it.

The formula was stated to be:

=Pages[Page-4]!Shape.19.Prop.Project

And should instead be:

=Pages[Page-4]!Shape.19!Prop.Project