Shared Workbook Limitations

[JanetW]

Can anyone suggest a practical limit for the number of user
simultaneously accessing a shared Excel workbook? We've been up to te
without noticable problems. At what point do I need to star
considering using a different tool, which would mean getting someon
else to do it (time and money)?

Thanks for recommendations

 

[Bob Phillips]

IMO shared workbooks are not worth the effort. If you have an important app
that you want to be shared, it should be deployed on a more resilient
platform than Excel. See Limitations of shared workbooks in help to see
what you can't do.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[JanetW]

Unfortunately, other development platforms are not an option for u
(don't have the most responsive IT department). The limitations o
shared workbooks are all acceptable. In fact, they fit perfectly wit
how the workbook is used; and any effort to "re-engineer" it on anothe
platform would be 90% reinventing the wheel (based on the feature
shared workbooks provide). More specifically, we would likely lose mor
functionality switching to Access than we'd gain.

We are thinking of using the workbook/app in another area, but this ne
area would have twice as many people using it, thus the concern o
Excel's stability as more users are added (not that I would expec
Access to be any more stable with the same number of simultaneou
users).

IMO shared workbooks are not worth the effort. If you have a
important app
that you want to be shared, it should be deployed on a mor
resilient
platform than Excel. See Limitations of shared workbooks in help t
see
what you can't do.

-