I have a match formula that shows correct data from a second exel file but
when I close the second excel file the file with this formula replaces the
correct data to show #value. How can I chg the formula to not require the
second file to be one inorder to have the correct data?


OFFSET('U:\Department\General Accounting\Budget\2007\Data Files\[2007
Depreciation.xls]Software Amort'!$B$3,MATCH($A$1,'U:\Department\General
Accounting\Budget\2007\Data Files\[2007 Depreciation.xls]Software
Amort'!$A$3:$A$46,FALSE)-1,MATCH(V$6,'U:\Department\General
Accounting\Budget\2007\Data Files\[2007 Depreciation.xls]Software
Amort'!$B$1:$M$1,FALSE)-1)