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