Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
franky
 
Posts: n/a
Default linking data with other workbooks

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!

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you don't have many cells you're retrieving, you could give each of the cells
a nice range name. Then use those range names in your formulas.

franky wrote:

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!


--

Dave Peterson
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

In fact, if you have lots, you can use that same idea--it's just more work.

franky wrote:

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!


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking WorkBooks Based on Data Entered In One of Them GeorgeF Excel Discussion (Misc queries) 0 April 6th 05 02:55 PM
linking workbook data sir lancelot Excel Worksheet Functions 0 March 10th 05 04:03 PM
Linking Workbooks Dede McEachern Excel Worksheet Functions 0 January 21st 05 08:27 PM
Should Merging workbooks pick up new data or only edited data? Peggy L. Excel Worksheet Functions 0 January 13th 05 05:31 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 08:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"