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

Please guide.

Jitu

[JR]

....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
>
>