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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|