I have recently switched from Excel 2016 to Excel 2017 and when importing data from a .csv Excel formats the import as a table when I click on load. This means I then have to change the format to convert it to a range and then get rid of all the colour banded rows.
Is there a way to prevent this happening and have the import work similar to how it did in 2016?
Is there a way to prevent this happening and have the import work similar to how it did in 2016?