Author Topic: Insert cell reference from a different page  (Read 2947 times)

0 Members and 1 Guest are viewing this topic.

Sonartech

  • Newbie
  • *
  • Posts: 1
Insert cell reference from a different page
« on: August 03, 2009, 08:45:14 PM »
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

  • Jr. Member
  • **
  • Posts: 15
Re: Insert cell reference from a different page
« Reply #1 on: December 04, 2014, 05:00:32 PM »
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