This won't help for this situation, but .....

There are two kinds of shared workbooks, those that are corrupted, and those that soon will be.

Avoid shared workbooks, it's much safer to use Access if possible.