ExcelBanter - Update links - hyperlink issues

can anyone help pls?

"Tenk" wrote:

I have two workbooks, one is a master sheet which feeds data into a
receiving sheet. The receiving sheet is opened via a hyperlink
contained in the master sheet. When I alter cell contents in the master
sheet I want them to be also updated in the receiving sheet. However, it
would seem that as the receiving sheet has been opened by a hyperlink
the link between the two worksheets is not dynamic. Is there any way
around this?

Thanks

Tenk

--
Tenk
------------------------------------------------------------------------
Tenk's Profile: http://www.excelforum.com/member.php...fo&userid=9604
View this thread: http://www.excelforum.com/showthread...hreadid=266557