How to Import data from a different .xls file

  • Thread starter Thread starter Ron_Marin
  • Start date Start date
R

Ron_Marin

I'm running Excel'97. Within the same directory I'm trying to import data
into spreadsheet cell from a cell in a different .xls file. I've tried
='C:\Libraries\Documents\Spreadsheets\[Ron's_Budget_2010.xls]Expenses'!$A$2
but I get an error. Any ideas
Thanks
(e-mail address removed)
 
Let XL automatically create the link for you.

Open both WBs.

Click in the target cell and enter an equal sign (*DON'T* hit <Enter>),
Navigate to the source WB and click in the cell containing the data,
NOW hit <Enter> ... and you're done!

Your data is now displayed in the target cell.
Look in the formula bar at the formula (link) XL created for you.

Now, close the source WB and you'll see the link in the target cell expand
to include the FULL path to the source.

You can use this first formula as a starting point to create your own links,
or ... just let XL do it for you all of the time.
 
Another way.

Open both workbooks
Edit|copy the sending cell
Go to the receiving cell
Edit|Paste special|click the Paste Link button

Excel will build the formula for you.
 
Back
Top