ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to allow multiple users to update workbook (on network)? (https://www.excelbanter.com/excel-discussion-misc-queries/33110-how-allow-multiple-users-update-workbook-network.html)

quddusaliquddus

How to allow multiple users to update workbook (on network)?
 

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.
What happens if two users attempt to add data to row 10?

How do I deal with a situation where a user has added data to a row
e.g. row 10; and another user seeing row 10 as blank and attempts to
add data to row 10?

Note:
VBA Answers are also welcome

:)


--
quddusaliquddus
------------------------------------------------------------------------
quddusaliquddus's Profile: http://www.excelforum.com/member.php...o&userid=24756
View this thread: http://www.excelforum.com/showthread...hreadid=383278



All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com