Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Tracked changes (Excel 2002)

    Is there a way to use Tracked Changes in Excel and be able to print the changes, like Word redline and strike-out? We would like to print the document for a meeting where the changes can be discussed before accepting.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Tracked changes (Excel 2002)

    I do not think there is any way to display the 2 versions like workd does. Excel is just not meant to do that.

    The changes are stored in the comments. You could print the comments.

    Another option is to save the revisions to a new sheet and then print this summary sheet.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Tracked changes (Excel 2002)

    Thanks, Steve.

    I followed the directions to print the comments, but only the borders printed, not the text of the individual comments.

    I figured out the revisions history sheet and was able to print that. This may work for us.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Tracked changes (Excel 2002)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>My mistake.

    It has been a long time since I looked at that. They act like comments, but are not comments at all. I am not sure what they or if they are even accessible from VB.

    You will probably have to live with the HISTORY sheet approach, unless someone else knows a way to access the "revision" info.

    Steve

Posting Permissions

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