Multiple User Auto Update

[azza001]

Hi,

Hopefully someone can please assist.
I need to have a spread sheet visible to multiple users at the same time.
The Master Copy is the only one that needs to be edited.
The other users are purely a Read-Only.
Is there a way for the Read-Only to Auto Update, with out the user exiting out and Re-Opening Again?

Thanks in advance
Aaron

 

[dmt32]

Hi,
welcome to forum
If your users have access to your workbook over corporate network then as an idea, you could add button to their worksheet together with little code, this will allow then to copy (refresh) data from your master workbook to theirs.

Others here may have further suggestions

Dave