Prev: Conditonal Format based on multiple criteria
Next: change color font after updated
From: carlh on 24 May 2010 05:54
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
From: trip_to_tokyo on 24 May 2010 06:07
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
 | 
Pages: 1
Prev: Conditonal Format based on multiple criteria
Next: change color font after updated