View Full Version : share a excel document among several pc's

08-15-2005, 11:57 AM
Hey. Currently I am temping in a Call Centre.

They want to share an excel document, and for it to be available on all the pc's that are linked to a network.

I am not too hot on networks, and the IT pro is away.

Is it just a case of placing the file on the server?

Then how do each user access it?

I do not know the type of network we are running.

Any helps is greatly appreciated

08-15-2005, 01:18 PM
No, No, No, No, No... that is a horrible idea. You should wait for your IT pro to come back and laugh...

Sharing a file on a server and allowing many people to open/edit it is a horrible idea. File locks, overwrites, lost information, and lack of a decent change tracking system all make this a no win solution.

08-15-2005, 04:56 PM
if u use the server and log on as an admin u can create a folder with only the excel sheet in it. then using computer management set the permissions so that users have read only access.
best leave it to the it guy, if u mess it up, u wont be working as a temp in a call centre.

08-16-2005, 10:07 AM
Sharing an excel file is easy, Open the spreadsheet that you would like to share with other users and find "TOOLS" on the menu bar then select "Share WorkBook", in the pop up Window, check the box with the text showing "Allow changes by more than one user at the same time".
However, this file has to be copied to a common network share drive. Ask your Windows Administrator to create a share for you if necessary. If you already have one just use it.
When you have more than one user editing the file at the same time, remember to click on the save icon frequently so that you can see the changes made by other person.