remove Power Query queries while keeping the query output tables

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:

  1. unload Power Query
  2. convert each table to range
  3. load Power Query
  4. delete queries (M code)

Is there a better/faster way to achieve what I want?

February 17th, 2015 7:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics