How to reference cells in another workbook?

[path]

How do I reference cells in another workbook, within a
math formula? Thanks.

 

[Frank Kabel]

Hi
just open the second workbook. In the target workbook select your cell.
Enter the equatation sign '='. Now goto the second workbook and select
the reference cell.

without using this enter the following:
='C:\temp\[Book2.xls]Sheet1'!A1

Replace path, workbookname and tabname according to your environment
HTH
Frank