Perhaps a simpler and less error-prone way of doing this is to have one workbook that gets updated from the database and, linked to that, another workbook (or a series of workbooks, one for each user) that can be used for viewing. That way, there's no risk of the workbook that has to be updated by the system being locked by a user who forgot to open it as read-only. With the linking workbook(s), the data links can be refreshed on demand.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]