I'm using power query to join csv files in workbooks. For example each workbook pulls a key of customer information which is then used to match up with data used in different types of other queries.
Right now I'm just copy pasting the customer data query into a new workbook but its getting time consuming that every time a small change to the customer query needs to happen, I have to go into all the workbooks and modify it separately.
Question is does Office have some place I can centrally have queries that each workbook references so if a change needs to occur I can just change the query that one time?
Bookmarks