Help needed in updating excel worksheet values
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
|