Sharing Excel File

[andremayer]

Hi,

This is my problem. We have a shared network drive in our office here. But we have 1 excel file that I need to do modifications in and others need to as well. Problem is, that when someone else has it open, I can only do READ ONLY. I want to be able to modify and have others able to modify as well.

I am in my own sheet anyways and so are they. But it has to all be in 1 excel file for other backend things.

So how can I do that so that I can have 2 3 4 people with the sheet open and still be able to modify and save? Please and thank you!

 

[daverunt]

This is for 2007.

Don't know about earlier versions

http://office.microsoft.com/en-us/e...laborating-on-excel-data-HA010089896.aspx#BM5

Apparently In Excel 2003, go to Tools>Share Workbook, click "Allow changes"
checkbox