External reference

[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

 

[Harlan Grove]

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.

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