How to change the default of 30 days change history

A

Andy Smith

It's fairly well-known that a good way to reduce the size of an Excel
spreadsheet is to use the Tools / Share Workbook command to share it, reduce
or eliminate the number of days change history from 30, and then un-share it.

My problem is: 30 days seems to be a default -- even if you save the
workbook with one day and re-open it, it reverts back to 30. I suppose I
could write an Auto_New routine in Book.xlt that sets KeepChangeHistory or
ChangeHistoryDuration, or calls PurgeChangeHistoryNow, but is there a better
way, e.g., by (dare I say it?) modifying the registry?
 
B

Bob I

Humm, I set it to 5 days or 1 day here save it and it stays. On the
OTHER hand if you UNshare it, the "spinner" goes back to 30 days.
 
A

Andy Smith

I understand that, but as you point out, when I unshare it, it's back to 30
days again. I want all past, present and future spreadsheets to have no
change history, shared or not.
 
Top