Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I have a spreadsheet (FrontEnd.xls) whos cell gets data from another spreadsheet using (='C:\junk\[BackEnd.xls]Sheet1'!C3). I then close both spreadsheets and open BackEnd.xls and insert a column causing the BackEnd data to now be C4. Now when I open the FrontEnd.xls I am asked if I want to update the links. After choosing "Yes", the cell is still pointing to "'C:\junk\[BackEnd.xls]Sheet1'!C3" rather then to C4. Is there a way to have the FrontEnd.xls spreadsheet update cell references that have shifted because of insertions or deletion of rows and columns? The links work fine in the FrontEnd.xls as long as the BackEnd.xls cells dont change. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking WorkBooks Based on Data Entered In One of Them | Excel Discussion (Misc queries) | |||
linking workbook data | Excel Worksheet Functions | |||
Linking Workbooks | Excel Worksheet Functions | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |