You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
Almost certainly.
But you don't need to power query it fully.
Give the people their own sheets.
Import data from sheets into your book.
Turn them into tables if you need/want
Then you're linked to the raw data, you can do some simple cleaning if they fuck it up/ask them to change it when they do because they will have broken the world.
But if it's coming from salesforce, and you define what you're taking, then they just grow their export file (don't change its name so you can have salesforcedata_from_brian_010124-311224 etc etc) which expands monthly, your sheet looks at their sheets.