can excel worksheet file b shared n edited by 2 computers @ d same time if so how it can b achieved suggest me

[SeldomSeen]

can excel worksheet file b shared n edited by 2 computers @ d same time if so how it can b achieved suggest me

pls some 1 gimme a way 2 share a ms excel worksheet and it should be accesible for both users at a time and also it should b editable for both..i hv tried but 1 user can access n change the file the other can access only in read only mode ...gimme a way to do this process..thnks in advance

 

[sehar]

can excel worksheet file b shared n edited by 2 computers @ d same time if so how it can b achieved suggest me

It can be done with third party software such as SaaSy eXpresso, but you gotta pay for it.You can also try importing it to Google Spreadsheets which I believe allows simultaneous editing.In Office 2007, you can enable different users to simultaneously edit an Excel 2007 workbook by setting up the workbook as “shared”. You then need to save the workbook on an allocated network share, from where users can access and modify the data.Create the workbook and add the data. Then, on the Review tab, select the Changes group, and click Share Workbook. You can select your options here. In the Changes group, you can also select Protect and Share Workbook, so that other users cannot turn off Change Tracking.Saving the shared workbook will then prompt you about changes saved by other users. If you keep the shared workbook open, you can choose to be informed at specified time intervals about changes other users have made. If changes that you are making to a cell conflict with changes made by other users to the same cell, you are prompted to choose the changes that you want to keep.Distribute, Merge or Consolidate If you want to allow users to make changes to the data in a workbook, but want to control what changes are accepted in the final copy, you can distribute copies of the workbook to each user and then merge or consolidate the changes in each copy.After creating the workbook, set it up as a shared workbook from the Changes group in the Review tab. Then, distribute copies of the workbook. After users have made the changes in their copies and sent them back to you, save all the copies to a common location and click Compare and Merge Workbooks.You can also send copies of worksheets for separate data inputs and then collate these into a master worksheet. For this, each worksheet should have similar or identical layouts. Once you have received completed worksheets from each user, click Consolidate in the Data Tools group on the Data tab. You can choose to consolidate data by Position, Category, or 3D Formulas.

 

[sek]

can excel worksheet file b shared n edited by 2 computers @ d same time if so how it can b achieved suggest me

Even if it was recommended your idea would cause the OS great confusion when trying to save the document. The changes you make would constantly overwrite each other because the changes wont update on both systems. Unless both people make the same exact changes, the spreadsheet would become a horrible mess that you spend more time working out than just doing it yourself. Assuming you aren't making the same exact changes, since that would defeat the whole purpose of two people working on it, I do not suggest trying this method. If you want someone else to work on it, copy the file to some removable media and give them an actual copy to work with.

 

[seednaymus]

can excel worksheet file b shared n edited by 2 computers @ d same time if so how it can b achieved suggest me

Yes, you can. Do the following:1. With the workbook open in Excel, go to Tools>Share Workbook>Editing tab2. Click Allow changes by more than one user at the same time checkbox if needed and click OK3. Save the workbook if prompted4. Use File>Save As to save the workbook to be shared to a network location to which both users have access5. Email the other user the path to the network file