How many users can sucessfully use a shared excel workbook?

A

Andrew of EIT

8 Users are sharing a workbook with multiple sheets over a 100MB Network with
HUB. While Saving, users receive the message that they can no longer access
the workbook as it is unavailable. It is not all the users all the time, but
some of the users some of the time - no particlular user experiences the same
thing on an on-going basis. No users are stopping the sharing of the
workbook.
Microsoft help states that "several" users can share a workbook. How many
is "several"? and is what is happening indicitive of too many users?
 
G

gearoi

I don't know what other people think, but I'd never trust 8 people wit
one excel workbook... no matter what M$ say... sounds like a recipe fo
disaster... I'm sure you have your reasons but I'd try a workaround lik
using a database with built-in file locking. Maybe you're already usin
ADOs or something, I don't know
 
Top