Nov 02 2016
12:23 PM
- last edited on
Jul 12 2019
10:39 AM
by
TechCommunityAP
Nov 02 2016
12:23 PM
- last edited on
Jul 12 2019
10:39 AM
by
TechCommunityAP
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!
Nov 02 2016 02:31 PM
Nov 02 2016 02:38 PM
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.
Nov 02 2016 03:04 PM
Oct 02 2022 12:39 AM
@Sergei Baklan - You can copy and paste on the databodyrange instead of whole table. This can also be done automatically through code. Only for the 1st time you will have copy paste the table manually and delete connections or paste values.