ExcelBanter - Sections of Excel 2003 pivot €œblanked out€ in Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sections of Excel 2003 pivot €œblanked out€ in Excel 2007 (https://www.excelbanter.com/excel-programming/411246-sections-excel-2003-pivot-%E2%80%9Cblanked-out%E2%80%9D-excel-2007-a.html)

snicks

Sections of Excel 2003 pivot €œblanked out€ in Excel 2007

I have an Excel 2003 file with a pivot. When I move data from one area to
another within the pivot, areas are being blanked out if I attempt this in
Excel 2007. In Excel 2003 I have no such problems.

If I change the fill for the impacted areas to €œno fill€ I can once again
see the data. However the next time I move data between pivot regions, areas
are once again €œblanked out€ in Excel 2007.

All times are GMT +1. The time now is 05:39 AM.