I strongly advise you to implement this "solution". The shared workbook feature
of Excel is very flaky at best, if you do a search on this feature in this
newsgroup, you will see quite some posts on the subject. Loss of data,
corruption of the file, wrong data saved, edits lost to mention just a few
If you are using a mixture of Office 2003 and 2007 then sharing workbook is
even more troublesome, or even impossible.
You seriously need to look for a different solution to the problem for which
you are now using a shared workbook.
If multiple users really need to make changes to data, use a database
If not, then set the workbook's property to "read-only recommended", so that
each user gets to choose whether or not to open the file readonly. If a user
really needs to make changes, he/she can open the file in read/write mode ON
PURPOSE and make the changes needed.
Avoid sharing workbooks!!!
Jan Karel Pieterse
Professional Office Developer Association