Linked Cells not displaying most current data

I have one place I enter certain data in the workbook then it is used throughout the workbook by linking. For some reason the target cells are not being updated from the source cells. It shows old data. I am tring both: ='W2-E1'!$C$1 and with perenthesis =('W2-E4'!$C$1). Once I click into the cell and hit enter the formulas work again. I noticed this after I copied the sheet. Maybe that has something to do with it. Why is this happening.

Hi

Make sure tha Tools/Options/Calculation is set to Automatic.

Andy.

"hcamelion" <[email protected]> wrote
in message news:[email protected]...
>
> I have one place I enter certain data in the workbook then it is used
> throughout the workbook by linking. For some reason the target cells
> are not being updated from the source cells. It shows old data. I am
> tring both: ='W2-E1'!$C$1 and with perenthesis =('W2-E4'!$C$1). Once I
> click into the cell and hit enter the formulas work again. I noticed
> this after I copied the sheet. Maybe that has something to do with it.
> Why is this happening.
>
>
> --
> hcamelion
> ------------------------------------------------------------------------
> hcamelion's Profile:
> http://www.excelforum.com/member.php...o&userid=36736
> View this thread: http://www.excelforum.com/showthread...hreadid=567625
>

Yeah its set to automatic and I clicked on the Calc Now and Calc Sheet buttons. It's still not updating.