| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF linking to closed workbooks.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Files that are closed | Excel Discussion (Misc queries) | |||
| Copying From Closed Workbooks | Excel Worksheet Functions | |||
| Information from Closed workbooks | Excel Discussion (Misc queries) | |||
| Linking to a closed workbook | Excel Worksheet Functions | |||
| linking problem with closed documents | Excel Worksheet Functions | |||
Threaded Mode
