| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
update workbook links over network
Hi i have 2 workbooks one is where i can enter details in to it called
planner, i have a second called display where i have paste linked cells from planner into the display workbook, if both workbooks are open on the same pc, the display workbook is updated instantly, but if i open the display workbook on a different pc on the same network it onlu updates the cells on opening when it asks to 'update' any idea how to get it updating instrantly? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
update workbook links over network
It's never going to update, "instantly" because its going across the network
and that involves an inherent delay. Where are the 2 files held? On the first pc (and saved locally) or on a network drive? "carlh" wrote: Hi i have 2 workbooks one is where i can enter details in to it called planner, i have a second called display where i have paste linked cells from planner i nto the display workbook, if both workbooks are open on the same pc, the display workbook is updated instantly, but if i open the display workbook on a different pc on the same network it onlu updates the cells on opening when it asks to 'update' any idea how to get it updating instrantly? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not allow update for workbook w/ Links | Excel Discussion (Misc queries) | |||
| Update Links between cells of two worksheets in the same workbook | Excel Discussion (Misc queries) | |||
| workbook links to .xla file on the network | Excel Discussion (Misc queries) | |||
| How to allow multiple users to update workbook (on network)? | Excel Discussion (Misc queries) | |||
| inter workbook links do not update even when both are open ??? | Excel Discussion (Misc queries) | |||
Linear Mode
