Function works on Excel 2003, but not on 2007

Hi, this function works properly on Excel 2003, but not on 2007. It shows REF#

Formula:

=INDEX(INDIRECT("'"&$A$45&":\QC PRRF -

ACTIVE FILES\PRRFLOG\[PRRF"&TEXT(NOW(), "YYYY")&".xls]Sheet1'!$A$1:$A$6000"),

(MATCH(IF(ISERR("*"&$B$6&"*"+0),"*"&$B$6&"*","*"&$B$6&"*"+0),INDIRECT

("'"&$A$45&":\QC PRRF -ACTIVE FILES\PRRFLOG\[PRRF"&TEXT(NOW(), "YYYY")&".xls]Sheet1'!$K$1:$K$6000"),0)))

Thank you