Pivot table range selection gets messed up when opening a Excel 2003 document in Excel 2007? It happens on all excel document, where the entire column was selected for the range. After conversion to Excel 2007, the selected range is truncated to 16384 rows of data. We have way more rows in the spreadsheets than 16,384. This causes some of the data to be left out from the pivot table, which causes serious confusion. Click here to play the video of the issue  |
