software

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 amp; 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: www.excelforum.com/member.php...oamp;userid=33119
View this thread: www.excelforum.com/showthread...hreadid=529738....make sure you didn't inadvertently put an apostrohpe (') before the formula.

quot;jitu_tikiliquot; wrote:

gt;
gt; While trying to link F5 of Sheet2
gt; using = and selecting F5 of Sheet1,
gt; THE CELL IN SHEET2 SHOWS =SHEET1!F5,
gt; instead of the value of F5 in Sheet1.
gt;
gt; The cell in sheet is formatted(Border, colour, merged amp; centred cell).
gt;
gt; However I am able to link other cells of the worksheet to various other
gt; cells in other worksheets.
gt;
gt; Please guide.
gt;
gt; Jitu
gt;
gt;
gt; --
gt; jitu_tikili
gt; ------------------------------------------------------------------------
gt; jitu_tikili's Profile: www.excelforum.com/member.php...oamp;userid=33119
gt; View this thread: www.excelforum.com/showthread...hreadid=529738
gt;
gt;