General discussion

Locked

network/sharing workbook

By jvdewaard ·
Using a WinXP SOHO P2P windows network.
Excel = Excel 2002, on 1) XP machine and 2) Win98se w/ Excel 2002.
1. While the 'master' file resides on the XP machine, setting up the file for full access sharing, is it possible for the file to be updated by the 98 machine and have the update reflected back to the XP machine for "master file" updates?
2. Is There an easier way of currently updating the files, other than haveing the remote unit make the changes and then closing the program and then re-opening the file to publish the updates?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by jstafs In reply to network/sharing workbook

YES there is an easy way to share data in Excel.

1 Click tools, then click Share Workbook.
2 Check the checkbox that allows changes by more than one user at same time.
3 click advanced tab, and under update, click save every X minutes. I always set mine to save every 5 mins.

Hope this is what you are looking to do.

Collapse -

by jvdewaard In reply to

Poster rated this answer.

Collapse -

by sysnetmgr In reply to network/sharing workbook

The important thing is the File / Save. We share workbooks through a network which we have open all day. We have to remember to do a save before we enter in any data, then do another save when we have finished. This is true for cells with calculations, they will not update until you do a file / save.

Collapse -

by jvdewaard In reply to

Poster rated this answer.

Collapse -

by jvdewaard In reply to network/sharing workbook

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums