Hi Madhu,

Objective : To create an excel database which should allow updation by
multiple users at the same time in a networked environment.

Please let me know how this can be done.


I'd recommend to do this in Access, not Excel. The only reliable way to
use Excel for this is when you use Excel as the front-end and in the
back an Access database to store the data. But that isn't easier than
using Access from start.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com