The only time I've shared a workbook, it had over 2000 records and wa
being shared by up to ten people at a time. At times it saw prett
heavy updates (over 5000 cells editted in the span of a few days), bu
most of the issues that came up turned out to be user related.
One thing I did have to change was the frequency of the automati
saves/updates. It's a trade-off between timely data and having multipl
people trying to save at the same time. It was a large file and took
few seconds to save. The more frequenly you auto-save, the more likel
there will be delays due to multiple saves happening at the same tim
(some people thought there machine was locking up). But if I saved i
less frequently, people would get concerned that their changes weren'
showing up on other people's screens
