Forum Discussion

Adeboy2K's avatar
Adeboy2K
Copper Contributor
Mar 29, 2020

How to get new column in excel data connection

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

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 29, 2020

    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.

Resources