I am trying to make an Excel spreadsheet so that people from different departments can put information into it and then we can save it as one spreadsheet -- my hope is that from this spreadsheet we could see at any particular time just where this particular item is in our manufacturing process or when it left.
I have put the spreadsheet in a shared folder and mapped a drive to the spreadsheeet. I am using 2007 and the other people are using 2003. I have made saved the file so that it is in compatibility mode. They can put the information in, but they can not save the information to make the change. I really don't want to get into merging spreadsheets and to have someone in one department commit to doing this (especially when we are busy) pretty much defeats the purpose of the idea.
Any ideas of what I can do?