Cell reference between worksheets

[jitu_tikili]

While trying to link F5 of Sheet2
using = and selecting F5 of Sheet1,
THE CELL IN SHEET2 SHOWS =SHEET1!F5,
instead of the value of F5 in Sheet1.

The cell in sheet is formatted(Border, colour, merged & centred cell).

However I am able to link other cells of the worksheet to various othe
cells in other worksheets.

Please guide.

Jit

 

[Guest]

....make sure you didn't inadvertently put an apostrohpe (') before the formula.