Step-by-Step 1 – Open a Non-Native File Directly in Excel

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. ................
................