Forum Discussion
Solved
Manually updating Tables?
Hi, I have created a tool to be used by people who are not excel pros. The tool accepts data from 2 or more csv-style reports (output from other programs) and uses it to calculate a data pres...
ColinJHarrison Hi Colin. 'The article in the link below, demonstrates how you can connect PQ to files on Sharepoint or an entire Sharepoint folder.
https://www.myonlinetraininghub.com/get-data-from-onedrive-or-sharepoint-with-power-query
ColinJHarrison Well, Power Query is the tool for you. Set it up correctly once and teach your users to press one button, every time the CSV data changes. No manual process, whatsoever.
Hi Riny! Yeahhh, I know... In principle... And in the long run that will probably be the solution I work towards, but my desire to provide a slightly more "hands on" solution in the short term is partially a change management thing, partially an issue with network accessibility (for me).