How to break the connection of an exported Microsoft Excel to SharePointĮven if you change something on the original list, those changes won’t reflect automatically on the exported file.īut if you really want to sever the connection permanently between the Microsoft Excel exported file and its source SharePoint list, then do the following: This feature is handy especially when you have Excel charts and graphics based on the data and you need to update those data on SharePoint. If you change something on the exported file, those changes won’t reflect on the original list.You can refresh the data on the exported file to reflect the changes from the original list.Note: You can also achieve the same results by clicking on the “ Refresh All” button found on the “ Data” tab in Excel. To refresh the data on the exported Microsoft Excel file, go to the “ Table Design” tab and click on the “ Refresh” button. The good thing with exporting a list to Excel (not as CSV) is that whenever you make any changes in the list, you can reflect those changes in the exported file. How to refresh the data in an exported Microsoft Excel from SharePoint ![]() Note: If you want to see all the columns, make sure the list view is not grouped before exporting the list as grouped columns don’t get exported. If you don’t see some of the columns, then you need to go back to the list and make sure all the columns are visible in your view. That’s it! You can now see the contents of the list right on the Excel file you exported. Click the “ Enable” button if you trust the source. You might be greeted with a security notice from Excel. ![]() But don’t worry, the file type stands for “Internet Query” created by Microsoft. Now, if you choose “ Export to Excel”, the file will be named “ query.iqy”. Whichever you choose, you will then be able to either save and open the file or open the file directly (though the options depend on your browser). The same columns that you see now will be the ones that will be present in the exported file. Note: Make sure to configure the list in the view that you want to export. When you click on it, you will have a choice on how you want to export the list. Simply navigate to the list that you want to export and focus on the command bar. It’s really easy to export a list from SharePoint to Excel. How to export from SharePoint Online to Microsoft Excel Check out this article on how to import an Excel table to SharePoint Online. Note: You can also do the opposite - import from Excel to SharePoint.
0 Comments
Leave a Reply. |