Need some help with tips on sharing Excel file simutaneously among several users. Ok, let me see if I can explain: I have a Excel file on a network drive where several users have access to. I want a way so that those users can edit the same file (same spreadsheet or multple spreadsheets at the same time), such that the all the changes made by users will get reflected.

Yeah, basically I want Excel server like a sort of database... I know it is too much to ask, but due to time contraint, Excel is only what I can work with.

Any help is much appreciated!!

 

Can't do that with Excel, it's not designed that way. Sharepoint services may have some options, but for the most part you need a data base of sorts where only certain things are locked, not the entire document,

 

I use Excel 2000 and I believe you can do what you are asking.

1. Pull up the spreadsheet that you want to share.
2. Go to Tools and Click on Share Workbook.
3. Under the editing tab you should see a box that says : Allow changes by more than one user at the same time. This also allows network merging.
Check that box.
4. Next, click on the Advanced tab and there you can pick the options you want concerning tracking changes and updating changes, along with resolving any conflicts.

I believe that will do what you are asking. I hope this helps.

 

^^^^ wow...

 

Perfect advice.

also understand macros will not work with shared sheets.

 

yep, that's how we do it here....

 

thats good to know

There isn't a way to do that with Word, is there?

 

thanks a lot!!!!!!!!

Man, love acurazine, got questions, acurazine's got answers