Home » Forums » Open Source Learning Center » Question and Answer

Pivot Tables

Submitted by smytha6 on 12 November, 2012 - 22:26

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.

‹ Error copying a formula nested if with 4 price points ›
»

Pivot tables

Submitted by smytha6 on 12 November, 2012 - 22:41.

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

Submitted by Nick on 12 November, 2012 - 23:10.

 try: 73. Excel Tips - Fix Corrupt Spreadsheet

»