the contains of a cell with the contents of another cell

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

Press F9 or set Auto Calculation to On.

Sorry, neither of them worked.

Art W.