Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Dec 2002
    Location
    UK
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    share a excel document among several pc's

    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

  • #2
    Regular Coder
    Join Date
    May 2005
    Location
    Michigan, USA
    Posts
    566
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Note: I do not test code. I just write it off the top of my head. There might be bugs in it! But if any thing I gave you the overall theory of what you need to accomplish. Also there are plenty of other ways to accomplish this same thing. I just gave one example of it. Other ways might be faster and more efficient.

  • #3
    Regular Coder
    Join Date
    Jul 2005
    Location
    Guildford, UK
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  • #4
    New to the CF scene
    Join Date
    Jul 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •