+ Reply to Thread
Results 1 to 5 of 5

Shared workbook - Save history tab?

  1. #1
    Registered User
    Join Date
    11-02-2006
    Posts
    12

    Shared workbook - Save history tab?

    I've shared a workbook, tracked the changes to a new worksheet, printed the changes, and now I want to save the "history" worksheet that Excel automatically generated. Does anyone know if this is possible.

    Thanks so much!
    Sydni

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by smurphy812
    I've shared a workbook, tracked the changes to a new worksheet, printed the changes, and now I want to save the "history" worksheet that Excel automatically generated. Does anyone know if this is possible.

    Thanks so much!
    Sydni
    In Tools, TrackChanges, Highlight Changes, is a 'List to Sheet'

    this sheet is then a standard Worksheet and you can Edit - Move or Copy etc

    hth
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    11-02-2006
    Posts
    12
    I've done this, but when I save the file the worksheet doesn't save with the file. I have to regenerate the next time the file is opened. Any ideas?

    Thanks!
    Sydni

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by smurphy812
    I've done this, but when I save the file the worksheet doesn't save with the file. I have to regenerate the next time the file is opened. Any ideas?

    Thanks!
    Sydni
    Hi,

    The 'Track' is rather guarded in allowing access to it's data, one possibility for you is if you record a macro, and replace the code with
    Please Login or Register  to view this content.
    and in Macro, Options set to a ShortCut key (like Ctrl/Shift/H for 'History') then, with the History in view, press CTRL/SHIFT/H the data will be copied to a new sheet, this sheet will save with the workbook.

    Note, you will need to take the workbook off 'Share' to do the macro setup, but it will run as a ShortCut.

    Let me know how you go.
    ---

  5. #5
    Registered User
    Join Date
    11-02-2006
    Posts
    12
    Bryan,

    Thanks for the reply. I think this will work. I've tested breifly and all appeared as it should.

    Thanks again!
    Sydni

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1