Multiple employees writing to same Excel Spread Sheet

0 pts.
Tags:
Development
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??
ASKED: February 14, 2006  10:39 AM
UPDATED: February 15, 2006  8:56 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • MadDogDing
    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.
    0 pointsBadges:
    report
  • Chieri
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following