D
Damned88
The linked information only updates if the other workbooks are opened.
I have the correct path, however, the workbook only inputs a value if the
workbook with the data is open.
This if other workbook(Data) is not open=Value
=SUMIF('G:\COREFCO EXPANSION\Phase 2\(900-00-12-000) Construction\Cost
Control\JCRs\Budgets\[Expansion
Estimate.xls]Master'!$M$2:$M$10000,TEXT($B$7,"0")&"-"&TEXT($H$10,"00")&"-"&TEXT($A16,"00")&"-"&TEXT($A$2,"00"),'G:\COREFCO
EXPANSION\Phase 2\(900-00-12-000) Construction\Cost
Control\JCRs\Budgets\[Expansion Estimate.xls]Master'!$H$2:$H$10000)
This if opened=Correct Updated value
=SUMIF('[Expansion
Estimate.xls]Master'!$M$2:$M$10000,TEXT($B$7,"0")&"-"&TEXT($H$10,"00")&"-"&TEXT($A16,"00")&"-"&TEXT($A$2,"00"),'[Expansion
Estimate.xls]Master'!$H$2:$H$10000)
How can I make this work without having to open the database workbook?
I have the correct path, however, the workbook only inputs a value if the
workbook with the data is open.
This if other workbook(Data) is not open=Value
=SUMIF('G:\COREFCO EXPANSION\Phase 2\(900-00-12-000) Construction\Cost
Control\JCRs\Budgets\[Expansion
Estimate.xls]Master'!$M$2:$M$10000,TEXT($B$7,"0")&"-"&TEXT($H$10,"00")&"-"&TEXT($A16,"00")&"-"&TEXT($A$2,"00"),'G:\COREFCO
EXPANSION\Phase 2\(900-00-12-000) Construction\Cost
Control\JCRs\Budgets\[Expansion Estimate.xls]Master'!$H$2:$H$10000)
This if opened=Correct Updated value
=SUMIF('[Expansion
Estimate.xls]Master'!$M$2:$M$10000,TEXT($B$7,"0")&"-"&TEXT($H$10,"00")&"-"&TEXT($A16,"00")&"-"&TEXT($A$2,"00"),'[Expansion
Estimate.xls]Master'!$H$2:$H$10000)
How can I make this work without having to open the database workbook?