Hoping this is not too off-subject, but I'm having a problem with a
similar formula. I've created the formula by using concatenate to
create the reference to a cell in another spreadsheet, and then copied
and Paste/Special/Values the result of the Concatenate. I end up with
what I want, a formula such as ='c:\[385.xls]sheet1'!$l$4 but Excel
doesn't recognize the formula until I select the cell, hit F2 to edit,
and press Enter. Until I do that it just displays the formula itself
and not the result. I'd rather not do F2, Enter, several thousand
times to get it to recognize all my formulas. Is there another way to
get it to recognize the formulas?

Thanks.