External reference

  • Thread starter Thread starter David
  • Start date Start date
D

David

I'm using Excel 97 and trying to insert an external
reference to a cell in another workbook. What is the
process to accomplish that, or what is the syntax to enter
it directly?
I did it in Excel 2000, but don't remember how.

TIA
David
 
I'm using Excel 97 and trying to insert an external
reference to a cell in another workbook. What is the
process to accomplish that, or what is the syntax to enter
it directly?
I did it in Excel 2000, but don't remember how.
Click to expand...

If the workbook is open, something like

='[workbook file name.xls]worksheet name'!A1

If the workbook is closed, something like

='C:\a\long\subdirectory\path\[workbook file name.xls]worksheet name'!A1
 
Back
Top