Solved: need to multithread excel sheet so users can update/add data simultaneously

tjamnz · Sep 17, 2008

Hi, Im looking for some code examples so all users can all update an excel spreadsheet simultaneously (make changes/edit etc). Im having a little bit of difficulty finding documentation on this (how to's).

1. Each User would have their own copy of the original document
2. When a user makes a change, the form will update the master document in another directory.
3. This is to alleviate the problem of having multiple users only having access to the document, one user at a time.

Thanks for any good links/tips etc..

-t

lotuseclat79 · Sep 17, 2008

Hi tjamnz,

Why not use a shared memory approach with one instance of the excel spreadsheet, and locks for each of the fields in the spreadsheet? Treat the spreadsheet essentially as a matrix data structure and lock each cell or (row, column) pair such that each user upon opening the excel spreadsheet accesses it with a different thread which is created when each user "opens" the spreadsheet - i.e. allow multiple reads, single synchronized writes using locks which each user's thread must acquire to update the cell (row, column) and release for another user to be able to refresh that cell with the latest update to it.

Give it more thought along those lines. Perhaps there is a simpler way to express this.

-- Tom

tjamnz · Sep 17, 2008

good advice. thank you

Solved: need to multithread excel sheet so users can update/add data simultaneously

Top Contributors this Month

Recommended Communities