Help needed in updating excel worksheet values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use a sumproduct formula which links different files to a single file. The
formula is
=SUMPRODUCT(------($A$2:$A$400="SME-1736"),--($G$2:$G$400="Business
Solutions -
Dhaka"),--(TEXT($E$2E$400,"yyyymmmdd")="2007May10"),!$H$2:$H$400). The
problem is when ever I want to update the file it tells that the file has a
broken link. But when I open source file and manually update the update is
done without any problem. What is the solution to update the file without
opening the source fiel?

Thankning you in advance,
Sadat
 
Hi

Some functions (p.e. INDIRECT and as much as I know all array functions like
SUMPRODUCT) don't work with source data in closed file.

Get such data into separate sheet(s) using linking formulas. Then you can
use those as data source for your formulas.
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
Help on sumproduct function 8
Pushing my luck, Sumproduct based on current data 1
Sumproduct Help! 2
Need VLOOKUP to Work Two Ways 0
Sumproduct excluding multiple criteria 8
If Statement 1
excell windows 03 cond format help 6

Back
Top