* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here. Thank you.ĭihao - * Beware of scammers posting fake support numbers here. I will follow your steps to try to reproduce this behavior from my side. More importantly, if it is convenient, you can take a screen record of your steps to display your processes and the different result and send it via the
Different processes may also cause the different result at the end. If there are any differences from your process, please point them out. It seems that the data wouldn’t be moved around after I click Refresh the data in Excel. Then I inserted some new columns in the query table and enter some formula. I also tried to reproduce this scenario in Excel client, which I created a SharePoint Online list in a SharePoint site and get the list data in Excel client by click Data > Get Data > From The data, the data didn’t go into the right cells as your expected. From your description, you have a Excel workbook which you Get Data from SharePoint online site list, when you added a column in the workbook and refresh Thank you for posting your concern in this community.