Does anyone know how I can update a shared workbook that resides on
network drive in order that multiple users who have it open can se
other people's changes?

The worksheet is populated by way of a form which enters the data i
the next blank cell. If two users enter the data at the same time i
produces a conflict error on exit.

Is there a way of reflecting the changes made by other users before m
code runs to find the next cell and thus enter it in a truly vacan
cell?

Thanks

--
Message posted from http://www.ExcelForum.com