From: Ron_Marin on
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
Ron_Marin(a)Yahoo.com
From: RagDyer on
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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ron_Marin" <Ron_Marin(a)discussions.microsoft.com> wrote in message
news:DF99774B-23DC-4E50-A5E9-6AE66D609E91(a)microsoft.com...
> 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
> Ron_Marin(a)Yahoo.com


From: Dave Peterson on
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.

On 05/18/2010 12:47, Ron_Marin wrote:
> 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
> Ron_Marin(a)Yahoo.com