Hi All, hope you can help, I have a workbook that pulls information from another workbook.
The workbook is not updating when the source file is closed.
I am using the following formula:
=SUMIF('[Weekly Production 2018 Live Data.xlsx] Daily Summary 2018'!$7:$7,B2,'[Weekly Production 2018 Live...