Discussion Locked

share excel files over winnt4.0 network

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have three peolpe using win98 to connect to our win 4.0 nt network.all are using office 97 and want to share 10 excel files with each other. how do we set this up and will each be able to make changes at the same time or do they have to work on these files at differnt times.

5 replies

by tbradley

The easiest way is to set up a shared directory on one pc.... which holds all the excel files.
all the other PC's can map a drive letter to the shared directory, and use the files.

Problem is, only one will be able to be making changes. The remainder of the users can open the file, but as read only.

by jcombs

Answer 1 is mostly correct but here is the rest of the story: If you open the excel documents you want to share and click, 'Format' --> 'Share Workbook' you will be able to select an option to allow more than one user to edit the workbook at one time, this will also enable workbook merging. Hope this helps, Josh

This discussion is closed to new replies.