View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DonSpmp DonSpmp is offline
external usenet poster
 
Posts: 2
Default 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?