datas in workbook 2 is not getting updated when datas in workbook 1 is changed

[share knowledge]

Hi

Not sure what's wrong with the below formula

=IF(D7="current",SUM('[Jerry.xls]nv pl'!$B:$B=$A15)*('[Jerry.xls]nv pl'!$D:$D=$A$5)*'[Jerry.xls]nv pl'!$E:$E='[Jerry.xls]nv pl'!$E:$E)

I have two sheets, one sheet name is Jerry, where i have the information, the above formula is in the spreadsheet called Tom. Basically this formula helps in fixing the figures department wise from the Jerry spreadsheet to Tom spreadsheet based on the condition that the row 7 should have the term "current".

Now this formula is not working and i am getting false message.

Any help is appreciated.

Thanks