Multiple employees writing to same Excel Spread Sheet
We have started a new group at my company. We have several Excel Spread Sheets in a Shared folder. But only one can be in write mode at a time. If you're the 2nd person in the sheet & want to write to it. You have to get out & back in after the 1st person has already gotten out of the sheet. I have checked the properties in all of the sheet and have given everyone full control. How can we all be in the same sheet and be able to write to it without having to get out & go back in all of the time??
Software/Hardware used:
Software/Hardware used:
ASKED:
February 14, 2006 10:39 AM
UPDATED:
February 15, 2006 8:56 AM
Answer Wiki:
I don't think that is possible. As far as I know, Excel does not support any concurrency, so data would be constantly overriden if more than one person was allowed in the same sheet at the same time. Every save would overwrite the other's work.
Perhaps a database would be a better place to store the data that's in these spreadsheets. Even a MS Access database has support for multiple connections.
To see all answers submitted to the Answer Wiki: View Answer History.
Have you tried the Excel menu option, “Tools”, then “Share Workbook”? I’ve never used it before but it looks like it give you the ability to allow multiple users to update it at once. I’m sure if you use the Microsoft Excel Help to look up “Share Workbook” you can get whatever tutorial the help can provide.
Hello,
Excel isn’t multiple-user. there is a possiblity to make the
workbook shared (Tools – Share workbook). Any changes by any user still must be saved before they can be seen by another computer. Conflicts (multiple changes to the same cell) are resolved at that time. Your projector computer will have to reopen the file to get the latest stuff.
Cherry