External xls reference error

F

Fluke

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup count? 4
Offset,Indirect Please help 1
Calc. Avg. Instead of SUMPRODUCT 4
Formula to determine number of current records by week 6
Formula to count data in a column that falls between a range 3
lookup over several columns 2
lookup 1
Build a reference to another worksheet from cell values in currentsheet 3

Top