Query Editor - Add new cols from Sharepoint

[Sachin Bafna]

Hi,

I have an excel which is having extracts from sharepoint. I have built a common worksheet which is combining the output of multiple sharepoint extracts.

The sharepoint has now been updated with new columns, but I am unable to view those columns in my excel.

I even tried adding the columns by clicking the Advanced Editor and adding the column names, but it did not work.

How do I get those new columns which are created in sharepoint into my excel as well.

Note: I am using MS Office 365 ProPlus. Not sure if this is Excel 2016 or even a higher version.

Unfortunately I am unable to share a copy of that file. My sincere apologies.

Thanks and regards,
Sachin

 

[Chihiro]

There are many things that will have impact.

How did you set up the Excel to connect with SharePoint? Was it through Export to Excel dialog menu on your SharePoint site?

If so, was the View where you performed export function updated to show the newly added column?

Or, are you querying underlying database using ADO, making connection via PowerQuery? etc etc.

Give as much detail of your process as you can, in order for us to better help you solve your issue.

Edit: I see that it was PowerQuery. Now, which function or path did you use to connect to SharePoint? If you connected to specific View of the list, likely unless that's updated, you won't see the new column.