In a cell in workbook no.1 I have this eneterd No.8-CRP-B1,
in a cell in workbook no.2 in A7 i want to link this cells so it reads the same and will update when updated. so I opened bolth notebooks when into workbook no.2 and cell A7 entered = and then highlighted the cell in workbook no.1 for some reason I get the response #value why is this? when I do this with other cells I have no problem? Thanks for the help.