I am using Excel that comes with Office 365. And this version of Excel does something annoying that's breaking all my macros.
I want to import a CSV file into a sheet WITHOUT any table formatting and such. This was the default behaviour in older versions of excel. But now that the table formatting is there, it's destroying all the macros that I have programmed.
But that's not what I'm getting. Here's what I did.
This green formatted table is breaking my macros. I want to import the csv as a plain spreadsheet with no formatting, no drop down header functionality etc…I want just a normal basic spreadsheet. How do I get Excel to do this?