Suppose if I type 'ABC' in 'A3' & 'DEF' in 'C4' on worksheet1 cells an

I wish them to automatically show in certain cells in other worksheet

(and also may be other workbooks.
I tried to enter =Sheet2!D19 in sheet1 A1 cell. It works fine if
had contents in sheet2 d19. But if I changed the contents in Sheet2 D19
The content in sheet1 A1 doesn't change to new content. It still show
the old content! It also only show me '0' if I enter the formula befor
I type in any content. And it also just remain '0' even after I entere
text in sheet1 A1. Can someone pls help

--
mlton
-----------------------------------------------------------------------
mltong's Profile: http://www.excelforum.com/member.php...fo&userid=3000
View this thread: http://www.excelforum.com/showthread.php?threadid=49689

Do you have manual calculation set? Check Tools>Options>Calculation, and
ensure the Automatic button is set.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mltong" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Suppose if I type 'ABC' in 'A3' & 'DEF' in 'C4' on worksheet1 cells and
>
> I wish them to automatically show in certain cells in other worksheets
>
> (and also may be other workbooks.
> I tried to enter =Sheet2!D19 in sheet1 A1 cell. It works fine if I
> had contents in sheet2 d19. But if I changed the contents in Sheet2 D19.
> The content in sheet1 A1 doesn't change to new content. It still shows
> the old content! It also only show me '0' if I enter the formula before
> I type in any content. And it also just remain '0' even after I entered
> text in sheet1 A1. Can someone pls help?
>
>
> --
> mltong
> ------------------------------------------------------------------------
> mltong's Profile:
http://www.excelforum.com/member.php...o&userid=30001
> View this thread: http://www.excelforum.com/showthread...hreadid=496894
>