ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Update Worksheet on Network by Multiple Users (https://www.excelbanter.com/setting-up-configuration-excel/216592-update-worksheet-network-multiple-users.html)

Angelik29

Update Worksheet on Network by Multiple Users
 
Hi, How can I let multiple users (on a network) update an Excel Workbook at
the same time? E.G. If there are rows of data on a Worksheet, how
can I let multiple users all add new rows simultaneously? Please note I have tried enable share workbook but there are conflicts when users are adding new rows, what I want is to ensure that they may all add rows to the same worksheet at the same time but without getting conflicts in regards to data input to the same row number. (not sure if I'm explaining myself very well here.) I'm using it in a windows environment and its version 2003

Note: I am buidling a workbook of data rather like a database but I want to
do this within Excel and not Access.







All times are GMT +1. The time now is 11:42 PM.

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