Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Shared workbooks' change history

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •