Workbook linking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sanders - 25 Jul 2006 13:43 GMT

Is there any way of linking individual worksheets in a workbook to
separate workbooks so that they will automatically update? Just cutting
and pasting messes up the formatting and loses the charts.
Thanks

Signature

sanders

Reply to this Message

Bernard Liengme - 25 Jul 2006 14:24 GMT

Open the two workbooks; let's call them Target and Source
In A1 of Target type =, then click on cell D1 of Source
Now click the green checkmark in the formula bar (or press ENTER key)
This gives you the formula =[Source.xls]Sheet1!$D$1
If the file name has spaces you get ='[The Source.xls]Sheet1'!$D$1
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Is there any way of linking individual worksheets in a workbook to
> separate workbooks so that they will automatically update? Just cutting
> and pasting messes up the formatting and loses the charts.
> Thanks

Reply to this Message