How to get new column in excel data connection

%3CLINGO-SUB%20id%3D%22lingo-sub-1262094%22%20slang%3D%22en-US%22%3EHow%20to%20get%20new%20column%20in%20excel%20data%20connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262094%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20an%20excel%20data%20connection%20to%20a%20CSV%20file%20on%20a%20website.%20A%20new%20column%20is%20added%20daily%20to%20the%20source%20CSV%20file%2C%20however%20the%20data%20in%20my%20excel%20file%20does%20not%20update%20with%20the%20new%20column%20when%20I%20refresh%20the%20connection.%20How%20do%20I%20resolve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVersion%20of%20Excel%20I%20am%20using%20is%20Office%20365%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1262094%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262184%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20new%20column%20in%20excel%20data%20connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262184%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F599562%22%20target%3D%22_blank%22%3E%40Adeboy2K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUsing%20formula%20bar%20or%20Advanced%20editor%20change%20%3CSTRONG%3EColumns%3D38%3C%2FSTRONG%3E%20or%20like%20(number%20is%20number%20of%20the%20columns%20you%20have%20here)%20parameter%20in%20%3CSTRONG%3ECsv.Document%3C%2FSTRONG%3E%20on%20%3CSTRONG%3EColumns%3Dnull%3C%2FSTRONG%3E%20or%20remove%20it%20at%20all.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

1 Reply
Highlighted

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