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? 2
sorting data in another sheet 2
HELP: IF Statement between Dates for Reverse Index failing 0
Formula to count data in a column that falls between a range 3
lookup over several columns 2
VBA code to open cetain books 0
help with this VBA code to open cetain books 0
Hate DBL post but I really need help 0

Top