Hello Everyone:

I am using Excel 2007, I am trying to fill the contains of a cell with the contents of another cell, so that when the first cell is changed the second cell is updated automatically. If I put the following code in the contains of the cell is updated. But if I go back and change the first cell nothing happens.

='[A565]565 A'!C14

What am I doing wrong?

Thanks

Art