Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlight changes to data (2003)

    I have a worksheet which contains external data in a table. When the data source is refreshed a small percentage of the data changes. Is there any way to get excel to highlight the changes. This will make it easier to see what is new/changed without having to check with a previous version of the worksheet.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlight changes to data (2003)

    Not that I know of - comparing to a previous version is probably your best bet.

    (Track changes works only in shared workbooks in Excel, and sharing workbooks is not a good idea.)

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Highlight changes to data (2003)

    Excuse my ignorance Hans, but why is sharing workbooks not a good idea.

    I'm in Excel forum now trying to learn Excel, wish me luck.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlight changes to data (2003)

    Excel was never built as a shared application. The code to share workbooks was added as an afterthought and has never worked very well. Shared workbooks tend to become corrupted frequently. If you want to share data, Access is a far superior choice.
    Legare Coleman

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Highlight changes to data (2003)

    Thanks Legare, i thought that was true in the past, however i had no idea about what the situation was currently.

Posting Permissions

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