Hi, I am having a problem linking two separate excel sheets. I use a formula to get one sheet (let's call it "B") to link to another ("A"). Sheet B just needs to be a copy of A, as I do all my calcs on A. It works at first when it ties to formula to that specific cell i.e. A$1$ instead of A1.

However, when I remove the $ so I can copy and paste the formula across the sheet, the cells do not show the values ("21", "January" etc) but the formula itself ("='[excelB]sheet1'A1!")

Does anyone know why it is showing the formula? I have tried changing the format of the cell to other types (General, Currency, Text etc) but to no avail

Thanks in advance