Software

Ask something
Discussion Locked

network/sharing workbook

0 helpful
5 replies

by jvdewaard

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

5 replies

by jstafs

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.

by sysnetmgr

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.

This discussion is closed to new replies.