SUMIF for closed workbook

[dinsey90]

Hi,

We have several target sheets that run using the formula below. I have been told that they always used to work without having the source book open but from researching online i dont see how it was possible as they have always been using sumif. could you have a look at the formula below and see how we could make it work without needing to have the source workbook open? Minimal changes would be fantastic as we have about 1000 spreadsheets that we would need to change this on.

Many thanks

=(SUMIF('T:\Folder1\SubFolder1\SubFolder2\[workbook.xlsx]Labour'!$A$19:$A$1048576,"<=28/02/19",'T:\Folder1\SubFolder1\SubFolder2\[workbook.xlsx]Labour'!$AF$19:$AF$1048576)+SUMIF('T:\\Folder1\SubFolder1\SubFolder2\[workbook.xlsx]Materials'!$A$9:$A$1048576,"<=28/02/19",'T:\\Folder1\SubFolder1\SubFolder2\[workbook.xlsx]Materials'!$E$9:$E$1048576))*(1+Fixover)

Many thanks

 

[Yongle]

Perhaps the workbook was opened via VBA to allow formula to be updated and immediately closed again via VBA and "they" did not notice that happening

  Dim wb As WorkBook
  Set wb Workbooks.Open("T:\Folder1\SubFolder1\SubFolder2\workbook.xlsx")
  wb.Close False