'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Copy Power Query Queries to Another Excel Workbook
Question details
The user needs to copy appended Power Query queries to a new workbook but receives a 'Download did not complete' error because the source connections are broken.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying an appended summary query from one workbook to another while preserving the original structure and logic.
- Observed behavior
- The transfer fails with a 'Download did not complete' error due to missing source tables (e.g., Table1) in the destination workbook.
Verify that you have full access to the original data sources and that the destination workbook is saved on your local drive before attempting to transfer the queries.
Recreate Source Tables in the Destination Workbook
Power Query requires the exact table names and data sources to function in the new workbook. Transferring these elements first resolves download and execution errors.
When copying a query, Excel attempts to bring over the logic, but it does not automatically duplicate the raw source data in the workbook cells. If the target workbook is missing essential elements like 'Table1', the query will immediately fail to load.
Open your original workbook and note down all the table names (e.g., Table1, Table2) that your appended Power Query relies on.
Highlight the data in the original workbook, press Ctrl+C, navigate to your new destination workbook, and press Ctrl+V to paste it.
Select the pasted data in the new workbook, press Ctrl+T to convert it into a Table, and rename it exactly as it was named in the original file (e.g., Table1).
Go back to the original workbook, open the 'Queries & Connections' pane, right-click the query you want to transfer, and select 'Copy'. Paste it into the 'Queries & Connections' pane of the new workbook.
Transfer M Code via Advanced Editor
Manually copying the M code ensures that the exact query logic is transferred without relying on Excel's clipboard for complex query objects.
Use WPS Office for Seamless Data Management
While Power Query errors in Excel can be complex to troubleshoot, WPS Spreadsheet offers an intuitive, lightweight alternative for managing, analyzing, and summarizing your data. Enjoy high compatibility with Excel file formats without the heavy system requirements.
- 1. Install WPS Office: Download and install the lightweight WPS Office suite on your device.
- 2. Import existing workbooks: Open WPS Spreadsheet and seamlessly load your existing Excel files without losing layout or data integrity.
- 3. Analyze your data: Use built-in Data tools and PivotTables to quickly append and summarize your data tables without complex query configurations.
Frequently Asked Questions
Why do I get a 'Download did not complete' error in Power Query?
This error typically occurs when a query is moved to a new workbook, but its underlying data sources or source tables (like 'Table1') are missing or inaccessible in the new file.
Can I copy a Power Query without its source data?
No, a query functions as a set of instructions applied to specific data. If the destination workbook lacks the referenced data or connection string, the query will break.
How do I find out which tables my query is missing?
Open the Power Query Editor in the original workbook, select your query, and check the 'Applied Steps' pane on the right. Click the gear icon next to the 'Source' step to see exactly which tables or files it references.
