Maybe I should also state that I am trying to have the dollar value displayed
in a cell on "One.xls" from a cell in "ClosedBook.xls"

Naturally, I want the cell in "One.xls" to be updated whenever the value in
"Closedbook.xls" changes

Thanks
Matt @ Launchnet

Launchnet wrote:
Well, I have a problem.

My open workbook is Named "One.xls"
My closed workbook is Named "ClosedBook.xls"
This "ClosedBook" is located as indicated in my code:

Here is my code:

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

Can someone tell me what I am doing wrong ?

The error message is: #NAME

Thanks in advance for the help

Matt @ Launchnet