Excel Pivot Tables (2007)

Make sure your data spreadsheet has no gaps or spaces in it. In order for Excel to properly identify the data source, all columns must be contiguous. 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. ................
................