I use power query to load data from external sources into several excel tables. Before sending this excel to a client, I would like to remove all power query queries (M code) while keeping the output/query tables at place.
My current workaround is:
- unload Power Query
- convert each table to range
- load Power Query
- delete queries (M code)
Is there a better/faster way to achieve what I want?