Link to home
Start Free TrialLog in
Avatar of Bharat Guru
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
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Tools-Share workbook. But be aware that this feature is not terribly well implemented and tends to cause corruption. If you need real multi-user access, then a database application would be better.
Regards,
Rory
Avatar of Bharat Guru
Bharat Guru

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
Avatar of Bert01
Bert01
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial