I have a new excel workbook that is using the Data -> Get Data -> From File... method to extract/copy a worksheet from another workbook. The new workbook is displaying what should be the first 10 rows at the bottom of the worksheet, rather than the top, after a series of blank rows. Why is the formatting so funky and how can I correct it? The clincher is that I'm not allowed to edit the original workbook in any way. I'm unable to link files for sensitivity reasons.

Thanks for any/all advice.