| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
link a local spreadsheet to a network shared spreadsheet
I have a local spreadsheet, Book1. Saved a copy of spreadsheet, Book2 on a
network shared directory. For any cells that are updated on local spreadsheet, Book1, I need to have the network spreadsheet, Book2 update with same changes. If I put formula on Book2 cell to = Book1 cell, the changes will update if I open Book2 on local PC. If another network PC opens shared Book2, the source is not available for the Book1 spreadsheet. What formula can I use so that a network PC view an updated shared Book2 linked to the local Book1 spreadsheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking excel spreadsheet from network | Excel Discussion (Misc queries) | |||
| A spreadsheet will not link to cells in another spreadsheet? | Excel Discussion (Misc queries) | |||
| pop up calendar on network shared spreadsheet | Excel Worksheet Functions | |||
| shared workbook, local temp-file and network traffic | Excel Discussion (Misc queries) | |||
| sharing a spreadsheet on a network drive | Excel Discussion (Misc queries) | |||
leo 
Threaded Mode
