Is there a limit on the number of users who can access and work within an Excel shared workbook at a given time? I've created a spreadsheet with some simple formulas applied to five of the columns (ie: If one field = X, display XX in another Field). There are 25 columns used with approximately 1000 rows. I first unprotected the spreadsheet, left five columns open so users could enter data, then protected the spreadsheet and the workbook.
The problem is that we have approximately 50-70 users who could possibly hit this spreadsheet during the day. We're finding a lot of locking errors occurring and data is being lost or users are not able to save. Many times it will advise them to save under another name.
Is the problem too many users, protecting the workbook or trying to save formulas inside the spreadsheet on this shared file?
I'd appreicate any help that can be given quickly. Thank you.