Shared files losing data! Help!

[FB]

I have several excel 2000 files (they were originally
created in excel 97) which are shared, by several users
(5-8) and they all have permission to change the cells.
The track changes is setup to keep history for 365 days.

These files have been working fine since 2001. In the
last few months, the users have reported missing data
sporadically, and recently is occuring more often and now
they are reporting that some times when they hit the save
button, they see a worksheet disappeared.

FACT 1:
I have discovered that the users have never "accepted or
rejected Changes" since these files were created. I was
wondering if there is a limitation as to how many
unaccepted or rejected changes can the history hold. The
files in question, can not display the history in full
(it crashes), I have to selected "since a date" in order
to be able to see the most recent history, otherwise it
crashes excel.

FACT 2:
I have search, the internet for a tool that would allow
me to repair or at least check to see if the history in
corrupt.

FACT 3:
I read that excel does not allow a worksheet to be
deleted if the workbook is shared. If this is true then
how come are the worksheets disappering?

My hunch is that this issue is related to the history
never been accepted or rejected.

Does anybody has any ideas?
Any help will be greatly appreciated

Thanks fb

 

[Frank Kabel]

Hi
to be honest: I won't rely on this Excel feature of 'shared workbooks'.
In most cases these ikind of application should be placed in a database
which allows multiple users to access the database at the same time,
etc.