Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Location
    Paignton, Devon, England
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    highlighting changes after pivot refresh (excel 2k)

    Does anyone know of a way of having changes in a pivot table highlighted after a refresh operation? With larger tables changes can be quite a challenge to spot! Haven't found anything in the literature, so I'm guessing I'll have to write a macro - unless you gurus know different.

    Thanks

    Graeme

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: highlighting changes after pivot refresh (excel 2k)

    I don't know of a simple way.
    Seems to me you need to paste-copy the pivot values prior to a refresh and use conditional format to show the differences.

    zeddy

Posting Permissions

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