Workbook linking

S

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble linking workbooks in excel to stay constant 2
Problems linking Excel ranges to Powerpoint 1
Excel 2013 vlookup to different workbooks not working 5
Get relative Path: advanced workbook linking. 1
Who is linking to my file? And what files am I linking to? 1
Linking Workbooks 2
correlating and summing data from multiple spreadsheets 1
Linking to individual Excel worksheets 1

Top