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?
|