hi,
i am using this formula to get value from another workbook
=COUNTIFS('D:\1.12.16\[3.9.19.xlsb]OL BC'!$B$10:$B$1000,G6,'D:\1.12.16\[3.9.19.xlsb]OL BC'!$H$10:$H$1000,">="&O6,'D:\1.12.16\[3.9.19.xlsb]OL BC'!$H$10:$H$1000,"<"&149)
this is working properly if workbook is open,
if i close 3.9.19.xlsb as referenced in formula then this formula giving an error #value

hope some one will help
thanx