Advertise on Bikeforums.net



User Tag List

Results 1 to 7 of 7
  1. #1
    Senior Member Snowsurfer's Avatar
    Join Date
    Mar 2008
    Posts
    271
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Computer Question: MS-EXCEL share a file on network

    Hello, a question about computing, under Windows XP. If I have a network with an MS-Excel file, how do I make it such that I can share this file, giving everyone on the network the ability to edit/update that file and save it?

  2. #2
    Senior Member donheff's Avatar
    Join Date
    Jun 2007
    Location
    Capitol Hill, Washington, DC
    My Bikes
    Specialized Tricross Comp
    Posts
    1,238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Right click on the file in Windows Explorer, select properties and check "read only." Then share the file on the network. People can still copy the file and alter their copies but they won't be changing the original.
    Every man is, or hopes to be, an Idler. -- Samuel Johnson

  3. #3
    Senior Member Snowsurfer's Avatar
    Join Date
    Mar 2008
    Posts
    271
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is there a way that the original can be modified by everyone?

  4. #4
    Blasted Weeds Tude's Avatar
    Join Date
    Aug 2006
    Location
    Rochester, NY
    My Bikes
    Trek 1200C, Specialized Rockhopper, Giant Yukon FX, Giant Acapulco
    Posts
    1,183
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Not that I know of. Only one person can be actually in it at one time. Rest is read only.

    The department I used to work next too - "share" and update this one spreadsheet all the time - and someone quite often has to get up and go find who's using the spread sheet at the moment so they can get out of it so the other person can dump their info into it.

    They also had problems with people using it - messing it up too. Too many hands in the pot.

  5. #5
    Senior Member deraltekluge's Avatar
    Join Date
    Sep 2006
    My Bikes
    Kona Cinder Cone, Sun EZ-3 AX
    Posts
    1,195
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Snowsurfer View Post
    Is there a way that the original can be modified by everyone?
    I don't know any reason why that file couldn't be as sharable as any other. Put it in a shared folder. To make a folder "shared", right click on the folder, select "Properties", then click the "Sharing" tab, and check the appropriate box.
    Last edited by deraltekluge; 08-06-08 at 09:50 AM.

  6. #6
    Squirrelly Member trsidn's Avatar
    Join Date
    Jul 2007
    Location
    Putting the 'fun' in dysfunctional
    My Bikes
    Cannondale CAAD8, Trek SU200
    Posts
    230
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by deraltekluge View Post
    I don't know any reason why that file couldn't be as sharable as any other. Put it in a shared folder. To make a folder "shared", right click on the folder, select "Properties", then click the "Sharing" tab, and check the appropriate box.
    Right, only one can do it at a time, however. But do you really want that?
    Quote Originally Posted by Nicodemus View Post
    Yet more proof that I'm.. well, pretty much right about everything.

  7. #7
    Wood Licker Maelstrom's Avatar
    Join Date
    Apr 2002
    Location
    Whistler,BC
    My Bikes
    Transition Dirtbag, Kona Roast 2002 and specialized BMX
    Posts
    16,888
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Snowsurfer View Post
    Is there a way that the original can be modified by everyone?
    If you mean it doesn't pop up with "this version is currently open by another user, this file will open read only" then yes there is a way.

    In 2003
    Tools - share workbook (something like that)

    in 2007
    Review -> Share workd book

    In both, I believe, there is a check box that says allow changes by more than one person.

    BIG CAVEAT. If you turn this on and two people are editing the same field, the last person to click save, wins the field war. The first persons info goes poof.

Posting Permissions

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