| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linkling workbooks on a network
Hi Is there anyway of making 2 spreadsheets to update each other with information? What I am looking for is 2 different spreadsheets to be open (on 2 different PCs on a network) and when information on one spreadsheet is entered that it automatically updates the 2nd spreadsheet – can this be done? Many thanks -- rufusf |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linkling workbooks on a network
Hi, Technically it is called linking files ... Practically just go ahead, while your two files are opened, simply 1. Type = in the destination workbook 2. Click on the cell you want in the source workbook ... HTH Cheers Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Sharing Linked Workbooks | Excel Discussion (Misc queries) | |||
| Linked network workbooks revert to pointing at my hard drive | Excel Discussion (Misc queries) | |||
| Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
| Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Linear Mode
