I have a spreadsheet that I want to be able to make changes to and also have other users open it up and be able to make changes to,
but when I make the changes, I want the changes to remain. When others make changes, I don't want the changes to remain in my saved version, but be able to save their changes to another file name. I was thinking to make it read only in properties, but then I cannot make changes. I would have to remember to check and uncheck the read only box. Is there a better way to do this using Excel 2007?
ANY help is greatly appreciated