Using an external range.

  • Thread starter Thread starter grumblenoise
  • Start date Start date
G

grumblenoise

Hi Guys,

How do I link to some data in an excel spreadsheet on my network? I've
created a document and I want to use the list from this central
document to save me updating my document. I can't remember how to
achieve this?

Help please.
 
If you just want to link to a particular cell in that workbook, then
it is easier to do so when both workbooks are open, and windows
adjusted so that both are visible. Then with the cursor in the
"receiving" cell, just type = then click on the window for the other
workbook, click on the worksheet and cell which will be "sending" the
data, and then press <enter>. Excel will have put in a formula like:

=[filename2.xls]Sheet1!A1

and when you close the "sending" workbook this will expand to include
the full path.

You can do a similar thing if you want to use VLOOKUP, so that Excel
works out the syntax for you.

Hope this helps.

Pete
 
Back
Top