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
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.