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