workbook linking cells not working within a workbook
 

I have been using Excel for years maybe I am getting old and forgetful but
why has my links from one cell in a sheet to another cell in another sheet
within same workbook stopped working. Its just specif to this workbook

ie below doesnt bring in the data to a sheet it just shows it as text

='Yr 06-07'!C156

workbook linking cells not working within a workbook
 

Dont worry I remember now. I need to re format the cells to say general, I
must have curruoted the format without realising. My memory returns !!!

"martyn" wrote:

I have been using Excel for years maybe I am getting old and forgetful but
why has my links from one cell in a sheet to another cell in another sheet
within same workbook stopped working. Its just specif to this workbook

ie below doesnt bring in the data to a sheet it just shows it as text

='Yr 06-07'!C156