How to get new column in excel data connection

[Adeboy2K]

I created an excel data connection to a CSV file on a website. A new column is added daily to the source CSV file, however the data in my excel file does not update with the new column when I refresh the connection. How do I resolve this?

Version of Excel I am using is Office 365

[#2]

@Adeboy2K 

Using formula bar or Advanced editor change Columns=38 or like (number is number of the columns you have here) parameter in Csv.Document on Columns=null or remove it at all.