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
Dave Peterson[_2_]
How to Import data from a different .xls file
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
