Excel - Sharing on a Network

H

Howard31

Hi all,

I'm looking for a way to make a workbook, sharable on a network, so that all
users can edit, and all new changes should be updated on everyone's computer,
even before the editor saves the new values. How do I begin? Has is got to do
with the Save Workspace (File Menu)?

Any help will be greatly appreciated!
 
G

Gord Dibben

Tools>Share Workbook is the usual method.

From help on Shared Workbooks.............

If you want to get automatic updates of the other users' changes
periodically, with or without saving, click Share Workbook on the Tools
menu, click the Advanced tab, and under Update changes, click the options
you want.



Gord Dibben MS Excel MVP
 
D

Doug Glancy

Hi Howard,

Save Workspace saves the open workbooks in their current arrangement -
doesn't have to do with sharing.

Doug
 
H

Howard31

Hi Gord,

I think you'll find that the Tools>Share Workbook will accept changes only
if the changes has been saved! I realy need to be able updating all the
sharing computers before the the computer that made a change has been saved.
 
G

Gord Dibben

That is not what Help says.
If you want to get automatic updates of the other users' changes
periodically, with or without saving, click Share Workbook on the Tools
menu, click the Advanced tab, and under Update changes, click the options
you want.
Click to expand...

Have you clicked on the "Advanced" tab and checked the options for updating
at a timed interval and seeing changes without saving?


Gord
 
H

Howard31

Hi Gord,

You're right, I didn't notice that option, Automatically every...>Just see
other users' chnages. Thanks for your help!
 
Top