Forum Discussion
Excel cell to populate from live sharepoint list
I have a sharepoint list for colleague assessments. Each time they are assessed we rate our colleagues from 1-4 on each of their different tasks. this is done on sharepoint. what i would like to do ...
You may connect to sharepoint list with Power Query and update the results with each opening of the Excel file and/or refresh by clicking on button.
thanks for that. are you able to point me in the right direction to doing that?
If you are not familiar with Power Query you may start from these support pages to check what's that.
https://support.office.com/en-us/article/get-transform-in-excel-881c63c6-37c5-4ca2-b616-59e18d75b4de
And you may google for tons of samples and tutorials. But that takes time to learn...
