file path: reference to other workbooks
Barb Reinhardt wrote...
In order for this to work, the workbook must be opened. Try
='c:\abc\[june.xls]total'!a1
....
If the workbook were open, the formula
=[june.xls]total!A1
would be sufficient because Excel won't load multiple files with the
same base filename, e.g., june.xls, into memory at the same time.
|