How many tracked changes can excel history hold?

[Fernando]

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, 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 fernando

 

[Raghu Prakash]

Hi Fernando,

As far as the information that i have on track changes in Excel...
History is kept only for a set interval When you turn on change
tracking, the history is kept for 30 days. This limit keeps workbook size
manageable. You can increase or decrease the number of days of history to
keep. If you want to keep the history indefinitely, you can specify a large
number of days, or you can make periodic copies of the history information.

How history gets deleted - Excel determines what history is kept by
counting back from the current date. Each time you close the workbook,
Excel erases any part of the change history that is older than the number
of days in effect the last time the workbook was saved.

For example, if you're keeping 30 days of change history, and you open a
workbook for the first time in two months, you'll be able to view the
history from two months ago. However, when you close this workbook, the
history from 31 to 60 days ago is deleted.

If you turn off change tracking or stop sharing the workbook, all change
history is permanently deleted.

History worksheet Excel can display a separate worksheet that provides
full details in list form, so that you can filter (filter: To display only
the rows in a list that satisfy the conditions you specify. You use the
AutoFilter command to display rows that match one or more specific values,
calculated values, or conditions.) to find changes of interest and print
the information. This History worksheet (History worksheet: A separate
worksheet that lists changes being tracked in a shared workbook, including
the name of the person who made the change, when and where it was made,
what data was deleted or replaced, and how conflicts were resolved.) is
useful when a workbook has lots of changes, or you want to investigate what
happened in a series of changes.

Please let me know has this helped You...
Thank You...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Fernando]

Yes, Thanks you.
Do you what happens when does changes get removed from
the history, before they were either accepted or rejected?
Is it possible that when they get remove, they are
automaticaaly rejected?