update workbook links over network

C

carlh

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
 
T

trip_to_tokyo

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 said:
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
Click to expand...

nto the display workbook, if both workbooks are open on the same
pc, the display workbook is updated instantly,
Click to expand...

but if i open the display
 
Top