Hello...I am having a link problem with two Ex2003 files. One references a cell in another. I use a formula like [filelocation][tab]$R$14 and have tried [filelocation][tab]$R14. The problem happens when a row is inserted above row 14 in the reference workbook. If both files are open, the link works fine and the formula updates to R15. If the one file is closed, when it is opened and UPDATE is selected it does not update correctly, and still points to R14. Am I missing something simple? Thanks. Tony