Bharat Guru
asked on
how to share excel file for multiple user
How to share excel file for multiple user,
I want UserA, UserB and UserC to add data entry for column 1 to column 6 on same sheet same time
OR
Users can use sheet1 for data entry and all users result will be merge on sheet2 but how can I push the result from all three users while excel is open on three seperate pc opening same file from network
I want UserA, UserB and UserC to add data entry for column 1 to column 6 on same sheet same time
OR
Users can use sheet1 for data entry and all users result will be merge on sheet2 but how can I push the result from all three users while excel is open on three seperate pc opening same file from network
ASKER
I'm lookig for some stable solution
You may want to take a look at Windows SharePoint Services (WSS) list feature. These lists can be accessed over the web by multiple users based on their role/security. You can use the list to gather data. The list can then be synchronized with the Excel workbook on a periodic basis either manually or automatically (using a macro or .Net code).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Regards,
Rory