A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How many tracked changes can excel history hold?



 
 
Thread Tools Display Modes
  #1  
Old May 20th, 2004, 12:54 AM
Fernando
external usenet poster
 
Posts: n/a
Default How many tracked changes can excel history hold?

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
  #2  
Old May 27th, 2004, 05:11 AM
Raghu Prakash
external usenet poster
 
Posts: n/a
Default How many tracked changes can excel history hold?

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.

  #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.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:52 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.