Excel Pivot Tables (2007)

For example, you cannot create a pivot table from data in columns A-D and columns L-N. The same holds true for rows – you cannot create a pivot table from data in rows 1-10 and 20-30. All columns of the spreadsheet with the data must have column headings. Excel will not recognize a column as being in the range if there is not one. ................
................