| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm trying to link two excel spreadsheets so they update automati
I am trying to link two of my Excel spreadsheets so that when i fill one with
data it automatically updates the other. Can this be done and how? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm trying to link two excel spreadsheets so they update automati
In the destination file type something like this on A1: =[Book1]Sheet1!$A$1
Only one thing. Make sure you have automatic calculation set on your options. "Michelle" wrote: I am trying to link two of my Excel spreadsheets so that when i fill one with data it automatically updates the other. Can this be done and how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a Problem Link in Excel | Excel Discussion (Misc queries) | |||
| Excel 2003 loses the links to other excel spreadsheets on a server | Excel Discussion (Misc queries) | |||
| How to link to an Excel file when sending an email in Outlook? | Excel Discussion (Misc queries) | |||
| Change in Link Behavior - Excel 2000 to 2003 | Links and Linking in Excel | |||
| how to link excel spreadsheets that are embedded in word | Excel Discussion (Misc queries) | |||
Linear Mode
