Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

Foo Off-Topic chit chat with no general subject.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 08-05-08, 10:48 PM   #1
Snowsurfer
Senior Member
Thread Starter
 
Snowsurfer's Avatar
 
Join Date: Mar 2008
Bikes:
Posts: 271
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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?
Snowsurfer is offline   Reply With Quote
Old 08-06-08, 07:22 AM   #2
donheff
Senior Member
 
donheff's Avatar
 
Join Date: Jun 2007
Location: Capitol Hill, Washington, DC
Bikes: Specialized Tricross Comp
Posts: 1,309
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
donheff is offline   Reply With Quote
Old 08-06-08, 09:27 AM   #3
Snowsurfer
Senior Member
Thread Starter
 
Snowsurfer's Avatar
 
Join Date: Mar 2008
Bikes:
Posts: 271
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Is there a way that the original can be modified by everyone?
Snowsurfer is offline   Reply With Quote
Old 08-06-08, 09:34 AM   #4
Tude 
Blasted Weeds
 
Tude's Avatar
 
Join Date: Aug 2006
Location: Rochester, NY
Bikes: Trek 1200C, Specialized Rockhopper, Giant Yukon FX, Giant Acapulco
Posts: 1,182
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
__________________
Tude is offline   Reply With Quote
Old 08-06-08, 09:46 AM   #5
deraltekluge
Senior Member
 
deraltekluge's Avatar
 
Join Date: Sep 2006
Bikes: Kona Cinder Cone, Sun EZ-3 AX
Posts: 1,195
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
deraltekluge is offline   Reply With Quote
Old 08-06-08, 09:52 AM   #6
trsidn 
Meadow Party Member
 
trsidn's Avatar
 
Join Date: Jul 2007
Location: Putting the 'fun' in dysfunctional
Bikes: Cannondale CAAD8, Trek SU200
Posts: 276
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(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 ElJamoquio View Post
.... Other than being completely wrong, you're correct.
trsidn is offline   Reply With Quote
Old 08-06-08, 10:17 AM   #7
Maelstrom 
Wood Licker
 
Maelstrom's Avatar
 
Join Date: Apr 2002
Location: Whistler,BC
Bikes: Transition Dirtbag, Kona Roast 2002 and specialized BMX
Posts: 16,885
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
Maelstrom is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 10:46 PM.