If by "will indicate" do you mean change to show the updated data, yes,
that's simple enough. It won't light up or anything.

In the second workbook, make sure your reference is dynamic, meaning it
looks into workbook1 itself for the information, and each time you open
workbook2 you allow it to update the linked data.

=[Book1.xls]Sheet1!A1


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61687