N
NWO
Greetings...
I have a 9 Meg Shared Excel file with about 30 worksheets that I use to
collect data from about 50 users. Problem is that sometimes users encounter
File Lock or Sharing violation errors. Lately, users have been complaining
that they enter thier data, successfully save the file, only to discover that
when they open the file again to review their input, their data is gone! Any
ideas as to why these error occur. My understanding is that Excel supports
up to 255 simultaneous users entering data at the same time. We don't have
users who enter data in the same cell at the same time. These problems don't
occur with all users, but see random.
We will be converting to a database to capture this data soon, but in the
meantime, we are stuck with the above situation.
Suggestion on how to solve the above issues are welcome.
NWO
I have a 9 Meg Shared Excel file with about 30 worksheets that I use to
collect data from about 50 users. Problem is that sometimes users encounter
File Lock or Sharing violation errors. Lately, users have been complaining
that they enter thier data, successfully save the file, only to discover that
when they open the file again to review their input, their data is gone! Any
ideas as to why these error occur. My understanding is that Excel supports
up to 255 simultaneous users entering data at the same time. We don't have
users who enter data in the same cell at the same time. These problems don't
occur with all users, but see random.
We will be converting to a database to capture this data soon, but in the
meantime, we are stuck with the above situation.
Suggestion on how to solve the above issues are welcome.
NWO