Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help needed in updating excel worksheet values
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. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "sadat" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating excel worksheet from an Access Query | Links and Linking in Excel | |||
Importing Excel Worksheet into word... help needed! | Excel Discussion (Misc queries) | |||
Regarding updating 1000 values using vlookup from another worksheet | Excel Worksheet Functions | |||
Updating Excel Worksheet | Excel Worksheet Functions | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |