Forum Discussion

Mark E Weisman's avatar
Mark E Weisman
Copper Contributor
Nov 02, 2016

Copying a Worksheet to a New Workbook without Power Query Tables, etc.

Does anyone know of an easy way to copy a worksheet from a workbook containing Power Query work to a New Workbook without any of the underlying Power Query objects?  I just want the Excel table in a new workbook!

BI & Data Analytics
Need Help

4 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Nov 02, 2016
    My guess is you shall remove all data connections in first workbook (or its copy) and after that copy all sheets from first workbook to another one. Power Query won't be copied, only sheets content
    • Mark E Weisman's avatar
      Mark E Weisman
      Copper Contributor
      Nov 02, 2016

      Yes, they can be removed after the sheet has been copied to a new workbook.  I'm looking for a way to ONLY copy the sheet content ... no subsequent (extra) steps to delete Power Query tables, etc.

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Nov 02, 2016
        I see. I meant not to remove Power Queries, only remove connections in Data=>Connections, however also some extra steps. On the other hand i think as far as sheet content is connecting to data model/power query they will be copied together.
        If you find something how to do please share, just intresting

Resources