Pivot Tables

One workbook, one data file, lots of Pivots off the same data file.

When I move between worksheets I get corruption in that previous worksheet is still partly visible "behind" the worksheet I now want to look at. No VBA, No Macro's - any explanation / cure? Think it's v2007.

Pivot tables

More info:- If I "refresh data" it clears the problem, but it returns next time I go to one Pivot table worksheet and then move to another...

Nick's picture

 try: 73. Excel Tips - Fix