Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How change days of change history tracking?
I am trying to use the Track Changes feature in Excel. When I save a
document where I have turned on Track Changes, it loses the tracking. There is no evidence that the changes were being tracked when I open the file again. I want to be able to review any changes for at least 2 weeks. The Microsoft Office Assistance help titled "About tracking changes" says "History is kept only for a set interval" then goes on to say this interval can be changed. The problem is it does not say where I can view and potentially change that interval. What do I need to do to use and modify this feature? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How change days of change history tracking?
Tools, Share Workbook... and click on the Advanced tab. Set the days in the
Keep change history setting as required. -- Hope this helps, MarkN "DonSpmp" wrote: I am trying to use the Track Changes feature in Excel. When I save a document where I have turned on Track Changes, it loses the tracking. There is no evidence that the changes were being tracked when I open the file again. I want to be able to review any changes for at least 2 weeks. The Microsoft Office Assistance help titled "About tracking changes" says "History is kept only for a set interval" then goes on to say this interval can be changed. The problem is it does not say where I can view and potentially change that interval. What do I need to do to use and modify this feature? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How change days of change history tracking?
Thanks MarkN. I found the settings you described but they were grayed out.
The faint font showed the default was 30 days. Now I am at a loss why the cells where I originally had "Track Changes" showing the cell corner mark plus the hover pop-up disappear after saving then closing the file. When I open it up again it is like I never had turned on "Track Changes." Ideas? DonSpmp "MarkN" wrote: Tools, Share Workbook... and click on the Advanced tab. Set the days in the Keep change history setting as required. -- Hope this helps, MarkN "DonSpmp" wrote: I am trying to use the Track Changes feature in Excel. When I save a document where I have turned on Track Changes, it loses the tracking. There is no evidence that the changes were being tracked when I open the file again. I want to be able to review any changes for at least 2 weeks. The Microsoft Office Assistance help titled "About tracking changes" says "History is kept only for a set interval" then goes on to say this interval can be changed. The problem is it does not say where I can view and potentially change that interval. What do I need to do to use and modify this feature? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How change days of change history tracking?
Tracked changes in Excel requires a workbook to be shared. When you select
Tools, Share Workbook and look at the Editing tab, is there a tick in the "Allow changes by more..." option. If not, put a tick in the box (and save the workbook), you can then go to the Advanced tab and change the keep change history option. Once this is on, you can display the changes using Tools, Track Changes and then selecting what changes you want to display or show all changes in the change history period on a separate sheet. -- Hope this helps, MarkN "DonSpmp" wrote: Thanks MarkN. I found the settings you described but they were grayed out. The faint font showed the default was 30 days. Now I am at a loss why the cells where I originally had "Track Changes" showing the cell corner mark plus the hover pop-up disappear after saving then closing the file. When I open it up again it is like I never had turned on "Track Changes." Ideas? DonSpmp "MarkN" wrote: Tools, Share Workbook... and click on the Advanced tab. Set the days in the Keep change history setting as required. -- Hope this helps, MarkN "DonSpmp" wrote: I am trying to use the Track Changes feature in Excel. When I save a document where I have turned on Track Changes, it loses the tracking. There is no evidence that the changes were being tracked when I open the file again. I want to be able to review any changes for at least 2 weeks. The Microsoft Office Assistance help titled "About tracking changes" says "History is kept only for a set interval" then goes on to say this interval can be changed. The problem is it does not say where I can view and potentially change that interval. What do I need to do to use and modify this feature? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I track half days in the attendance tracking template? | Excel Discussion (Misc queries) | |||
How to change outline when tracking changes in Excel? | Excel Worksheet Functions | |||
Can you change the PMT function tio calculate off of 365 days? | Excel Worksheet Functions | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |