View Single Post
  #3  
Old June 1st, 2004, 05:06 PM
Fernando
external usenet poster
 
Posts: n/a
Default 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.

.