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?


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC

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.

Andy Smith wrote:

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?

Exactly -- what I want is, no change history, ever.

--
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"Bob I" wrote:

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.

Andy Smith wrote:

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?

then select the "Dont't keep change history" button

Andy Smith wrote:

Exactly -- what I want is, no change history, ever.

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.

--
Andy Smith
Senior Systems Analyst
Standard and Poor''s, NYC



"Bob I" wrote:

then select the "Dont't keep change history" button

Andy Smith wrote:

Exactly -- what I want is, no change history, ever.

Then you will need to record a macro to do that.

Andy Smith wrote:

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.

An unshared workbook has no change history so no need to change anything.




On Tue, 23 Oct 2007 12:55:03 -0700, Andy Smith
wrote:

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.