Sumifs using vba in closed workbook

Hi everybody,
is there any way to sumifs values in the closed workbook using the vba without opening and closing "Data" file.
I know that i can't use sumifs in the closed workbook but maybe there is another way of how to do this in vba.

I would like to do this calculation every time i open the workbook, and if possible without opening and closing "Data" file, because this file is very heavy and my pc at work is slow.
Please see below the formula which i'm using now:

=SUMIFS('D:\Test\Data\[DataBase.xlsm]DataBase'!$U$2:$U$1048576,'D:\Test\Data\[DataBase.xlsm]DataBase'!$T$2:$T$1048576,T2,'D:\Test\Data\[DataBase.xlsm]DataBase'!$V$2:$V$1048576,AI6)

Thanks in advance

Hi Norie,
what do you mean by using entire column?
is it this:
=SUMIFS('D:\Test\Data\[DataBase.xlsm]DataBase'!U:U,'D:\Test\Data\[DataBase.xlsm]DataBase'!T:T,T2,'D:\Test\Data\[DataBase.xlsm]DataBase'!V:V,AI6)
It doesn't matter it can be entire column

Thanks in advance