PDA

View Full Version : Sleeper: How to allow multiple users to update workbook (on network)?



QAQ
06-29-2005, 10:32 AM
How can I let multiple users update a single worksheet over a network? e.g. how can I let different users simultaneously (on a network) add new rows to existing rows of data?

I know there's a function called Share Workbook under the Tools menu. I'm not sure how to use it (and I cant test it as I dont have access to a network at the moment).

Can sum1 help? :help

Jacob Hilderbrand
06-29-2005, 10:46 AM
Just enable sharing.

Tools | Share Workbook... | Allow changes from more than one user at a time.

Up to 256 users can have the workbook open at once.

QAQ
06-29-2005, 10:47 AM
But what will happen if two users add new row of data in the same row e.g. row 10?