Can you share a sample workbook or excel snapshot for reference? There might be a couple of things happening, some sample data would be helpful.
- Just Sort Your Data In a way that you Don't have any Null in like First 5 Rows and Reconnect
- If Above doesn't work then save your file as .csv and connect as Text File from Data menu.
Brilliant! The re-sort for no nulls in first 5 rows worked perfectly.
Thanks for your help