Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested IF SUMPRODUCT updating to closed workbook
Hello,
After viewing other postings, I understood SUMPRODUCT updates to closed workbooks. So I replaced SUMIF with the below working formula. I still have to update the file link values in order to populate with the closed workbook's values. Is there a way to update to the closed workbook without having to manually edit/update file link values? (fyi - the file contains links to numerous workbooks) =IF(BB261=1,BC86,SUMPRODUCT(--('Q:\Office Records\Finance\Forecast\2007\11+1\Debt Files\[2008-1.xls]Forecast'!$D$6:$Z$6=BA262),--('Q:\Office Records\Finance\Forecast\2007\11+1\Debt Files\[2008-1.xls]Forecast'!$D$5:$Z$5=BA261),--('Q:\Office Records\Finance\Forecast\2007\11+1\Debt Files\[2008-1.xls]Forecast'!$D$105:$Z$105))) Appreciate your advisement, Sharon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Closed External Refs | Excel Discussion (Misc queries) | |||
Updating Links from Closed Source Workbooks | Excel Discussion (Misc queries) | |||
Sumproduct wont update properly on closed workbooks | Excel Worksheet Functions | |||
Updating links to closed workbooks | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |