I am using a cell name to simplify my formulas

inside the cell that I named I put the path to a filename.
c:\users\documents\[filename.xls]


I have an Issue that when I create a simple formula like this
=[Filename]WK1!h22 it works just fine I get a result

But when I create a complex formula I get an #ref error when I step through
the formula.

If I take the complex formula and just type in the file name it works just
fine. So I do not understand why I can not just use the cell name because it
is essentially the same thing.