Linking separate sheets problem

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

Try this

=[excelB]sheet1!A1

Reason yours isnt working is for the following (highlighted in Red, its just the signs between different references);

='[excelB]sheet1'A1!

Originally Posted by Jamesr571

Try this

=[excelB]sheet1!A1

Reason yours isnt working is for the following (highlighted in Red, its just the signs between different references);

='[excelB]sheet1'A1!

Thanks for the reply, I was just using this as an example as I wasn't actually typing the formula out (instead writing = and then clicking on the relevant cell). Strangely seems to have fixed itself now... one of those gremlins I guess