Actually the second \ that you inserted should not be there.
It should be as I indicated:

='C:\extrafiles\SecondaryLevel[BofACheckRegister.xls]Payable'!CurrentBa
l

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup