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

"jitu_tikili" wrote:


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 other
cells in other worksheets.

Please guide.

Jitu


--
jitu_tikili
------------------------------------------------------------------------
jitu_tikili's Profile: http://www.excelforum.com/member.php...o&userid=33119
View this thread: http://www.excelforum.com/showthread...hreadid=529738