I am trying to use the following SUM function
"=SUM('[Interim Chart.xls]BS_Values'!$O$167:'[Interim Chart.xls]BS_Values'!$O$179)"
and that works perfectly. The problem is when I close the workbook that the function is referencing, which then looks like this,
=SUM('F:\Shared\Finance\XLFILES\BS\Chart of Accounts Export System\[Interim Chart.xls]BS_Values'!$O$167:'F:\Shared\Finance\XLFILES\BS\Chart of Accounts Export System\[Interim Chart.xls]BS_Values'!$O$179)"
I Get the REF error when the formula looks like that.
Is there anyway around this?
Bookmarks