Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
External xls reference error
I've got this formula:
=SUMPRODUCT(--('I:\IWS KPI\[All Approved Between Dates.Xls]Sheet1'!$B$2:$B$10000="IWS"),--('I:\IWS KPI\[All Approved Between Dates.Xls]Sheet1'!$C$2:$C$10000=Sheet2!B2),--('I:\IWS KPI\[All Approved Between Dates.Xls]Sheet1'!$C$2:$C$10000<=Sheet2!B3),--('I:\IWS KPI\[All Approved Between Dates.Xls]Sheet1'!$D$2:$D$10000="Approved")) in an xls file called Report.xls (in the same location as the referenced file). It only seems to want to update this formula when the other sheet is open. If it isn't it says 'Unable to open file'. Can anyone help? I've got to do similar formulae for other KPI xls files in the same Report sheet and don't want to have to open EVERY other file for this to calculate. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
External xls reference error
Sorry error is 'Unable to read file' not 'unable to open file'.
"Fluke" wrote: I've got this formula: =SUMPRODUCT(--('I:\IWS KPI\[All Approved Between Dates.Xls]Sheet1'!$B$2:$B$10000="IWS"),--('I:\IWS KPI\[All Approved Between Dates.Xls]Sheet1'!$C$2:$C$10000=Sheet2!B2),--('I:\IWS KPI\[All Approved Between Dates.Xls]Sheet1'!$C$2:$C$10000<=Sheet2!B3),--('I:\IWS KPI\[All Approved Between Dates.Xls]Sheet1'!$D$2:$D$10000="Approved")) in an xls file called Report.xls (in the same location as the referenced file). It only seems to want to update this formula when the other sheet is open. If it isn't it says 'Unable to open file'. Can anyone help? I've got to do similar formulae for other KPI xls files in the same Report sheet and don't want to have to open EVERY other file for this to calculate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External reference to a Column | Excel Worksheet Functions | |||
External reference not working? | Excel Discussion (Misc queries) | |||
input for external reference | Excel Discussion (Misc queries) | |||
sumproduct external reference | Excel Worksheet Functions | |||
External Reference | Excel Discussion (Misc queries) |