Shared workbooks' change history

Mudface · May 7th, 2002, 02:56 AM

I posted a while back about being unable to unprotect a shared workbook to erase it's change history and then reprotect it through VBA, even though the same sequence can be done manually.

To get round this, I set the period for changes to be kept to 32 days and wrote a small routine for our QA dept to extract (copy and paste) the change history to a separate workbook once a month.

The problem is, changes over 32 days old are still present in the change history list. The way I thought it would work is that changes would be kept up to 32 days and then sort of 'drop off' and so only a 32 day rolling period would be there, and the workbooks wouldn't 'bloat' over time. Can anyone explain why they're still there?

As a sidenote, I used the PurgeChangeHistoryNow method to try and delete changes, the workbook actually ended up bigger in size than before(!). I hate shared workbooks

.

[ This Message was edited by: Mudface on 2002-05-07 01:58 ]

Jack in the UK · May 8th, 2002, 01:29 PM

this sounds about right ive had simila why???

i feel its the changes take or bloat excel.. no other reason

May 8th, 2002, 01:29 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	this sounds about right ive had simila why??? i feel its the changes take or bloat excel.. no other reason __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 02:56 AM	#1
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	I posted a while back about being unable to unprotect a shared workbook to erase it's change history and then reprotect it through VBA, even though the same sequence can be done manually. To get round this, I set the period for changes to be kept to 32 days and wrote a small routine for our QA dept to extract (copy and paste) the change history to a separate workbook once a month. The problem is, changes over 32 days old are still present in the change history list. The way I thought it would work is that changes would be kept up to 32 days and then sort of 'drop off' and so only a 32 day rolling period would be there, and the workbooks wouldn't 'bloat' over time. Can anyone explain why they're still there? As a sidenote, I used the PurgeChangeHistoryNow method to try and delete changes, the workbook actually ended up bigger in size than before(!). I hate shared workbooks . [ This Message was edited by: Mudface on 2002-05-07 01:58 ]