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