I have some code that writes to a shaired workbook "data.xls" that about 10 users are using.

Every now and again they get a message saying that "data.xls" can now be opened for read/write access. You can then press Read/write or cancel.

Is how can i stop this as the work book should be open for write as it is shaired all the time.

Please help.