How many tracked changes can excel history hold?
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?
-----Original Message-----
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.
.
|