| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating linked spreadsheets
Hi...
I have two spreadsheets... parent_AB123.xls and child.xls. The child spreadsheet has a linked formula to the parent spreadsheet worksheet 'keys'. =[parent_AB123.xls]keys!A2 What I am trying to figure out is that how can I have the child updated automatically/semiauto(by using a reference to another cell maybe) to point to a new parent... say parent_AB_231.xls. The location of the new parent would be same but the older one would have been removed. -U |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Updating linked spreadsheets
in EDit /Links, you can change the linked workbook
"Uzy" wrote in message ... Hi... I have two spreadsheets... parent_AB123.xls and child.xls. The child spreadsheet has a linked formula to the parent spreadsheet worksheet 'keys'. =[parent_AB123.xls]keys!A2 What I am trying to figure out is that how can I have the child updated automatically/semiauto(by using a reference to another cell maybe) to point to a new parent... say parent_AB_231.xls. The location of the new parent would be same but the older one would have been removed. -U |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked spreadsheets failing to recognised that the linked file is | Excel Discussion (Misc queries) | |||
| Linked spreadsheets | Excel Discussion (Misc queries) | |||
| Linked spreadsheets | Excel Programming | |||
| Trouble Updating Linked Spreadsheets | Links and Linking in Excel | |||
| linked spreadsheets | New Users to Excel | |||
Linear Mode
