Workbook linking

[sanders]

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

[Bernard Liengme]

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sanders" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> sanders
> ------------------------------------------------------------------------
> sanders's Profile:
> http://www.excelforum.com/member.php...o&userid=36745
> View this thread: http://www.excelforum.com/showthread...hreadid=564678
>