And I just noticed the Data Preview Pane for the 2011 Orders sheet only goes to April 2011 rather than to December 2011. Is there a limit to what the Data Preview pane "sees"? The April to December 2011 data is in the dimensions and measures pane in the worksheet, but I don't see it in Data Preview. Any ideas?
The data preview pane is limited to 1000 rows therefore you are seeing until April. You can change the number to see more data e.g. you can change the number to 4500 to see all your 2011 data.
As for the additional table I am not sure what is causing this. But some of things we do in excel can be imported as a separate table e.g Naming a range. This might give you some clue Excel .
Thank you! I feel so silly because I didn't notice that drop-down, and the link you sent regarding Excel is perfect. Thank you!