I know you can link to another workbook in a formula, for example, =[mydata.xls]Sheet2!$E$1
My problem is the data workbook can change depending on the department and month and is stored in the cell F3.
I cannot seem to get =[f3]Sheet2!$E$1 to work. (F3 contains the text "mydata.xls")
The full path to the data is C:\Documents and Settings\my username\My Documents\PROJECT\ Report Data\mydata.xls
Any ideas please?