Thread: Cell Reference in LINK not updating Consistently when position changes

Excel 2010
Several files with various LINKS between them
When the LINKED CELL's position changes, the position is not updating correctly in the LINK FORMULA of the Destination File

IE:
Link is =X:\Server\12.13 budget\[00000-Budget_2012-2013_Budget_File.xlsx]Budget Draft 2012-2013'!$AE$1554
and we inserted a line in the WORKSHEET so $AE$1554 should have updated to $AE$1556, but it remains$AE$1554

++ Also using either = and navagatiing to the cell to link or using Copy PASTE LINK, sometimes the SERVER LOCATION is copied into the formula, sometimes it is not..

IE: =X:\Server\12.13 budget\[00000-Budget_2012-2013_Budget_File.xlsx]Budget Draft 2012-2013'!$AE$1554
will copy in as only ='[00000-Budget_2012-2013_Budget_File.xlsx]Budget Draft 2012-2013'!$AE$1554

Neither link formula is updating the cell reference in the link correctly

= Automatically Calculate is checked
= Source file was open and saved
= We checked Data EDIT LINKS and tried to update there
= We selected YES to update when the file was open.
= We checked the Linked Worksheet file locations in EDIT LINKS and they are correct

Further, while BOTH FILES ARE OPEN
-We Corrected the LINK to the Proper Cell
-Then we inserted a line in the SOURCE FILE
-Saved the FILE
The CELL REFERENCE in the DESTINATION FILE UPDATED for the LINK we just corrected, but not for the remaining old links changed from the incorrect cell reference

Sorry - this is a pretty confusing post.

When you are linking between files, AFAIK Excel cannot track changes between links unless both worksheets are open in the same instance of Excel. Do your experiences relate to instances when all the files are open?

The answer may be to use named ranges instead.

Not sure about part 2 of your question.

Hmmpff.. I tried to say it clearly..
Anyway Thanks

The second part is actually about what a LINK FORMULA should look like.
My Boss does not COPY and PASTE LINK
She has both files open and puts an = in the destination cell and then navigates to the cell in the source file to create her link formula.

What if find strange is that using this method, or copy and paste Link, that SOMETIMES the formula includes the SERVER in the ROUTING and sometimes it just includes the Folder and file and worksheet

IE:
=X:\Server\12.13 budget\[00000-Budget_2012-2013_Budget_File.xlsx]Budget Draft 2012-2013'!$AE$1554 <==has server X location
='[00000-Budget_2012-2013_Budget_File.xlsx]Budget Draft 2012-2013'!$AE$1554 <== does not have the server location