F
foofightin
My colleague is having trouble linking to another workbook, which he wants to
remain closed. The link looks like this:
=-SUMIF('G:\Master Appraisals & Cashflows\BLEL proformas\[BLEL - Northampton
J16 M1.xls]Array List'!$B$3:$B$26,"=01/08/2007",'G:\Master Appraisals &
Cashflows\BLEL proformas\[BLEL - Northampton J16 M1.xls]Array
List'!$C$3:$C$26)
Trouble is, we have around 16 workbooks we're linking in this way, so
amalgamating is not an option.
Can this work with workbooks when they remain closed?
Any help appreciated. Thanks, Greg
remain closed. The link looks like this:
=-SUMIF('G:\Master Appraisals & Cashflows\BLEL proformas\[BLEL - Northampton
J16 M1.xls]Array List'!$B$3:$B$26,"=01/08/2007",'G:\Master Appraisals &
Cashflows\BLEL proformas\[BLEL - Northampton J16 M1.xls]Array
List'!$C$3:$C$26)
Trouble is, we have around 16 workbooks we're linking in this way, so
amalgamating is not an option.
Can this work with workbooks when they remain closed?
Any help appreciated. Thanks, Greg