Download Did Not Complete in Excel? Look Here!

Power Query Download Did Not Complete in Excel

When you are dealing with large amount of data with the Power Query feature in Excel, you might receive an error message saying that download did not complete. To help you address the download did not complete in Excel, we have gathered some potential causes for you:

• The worksheet is protected.
• Your Microsoft Office is not updated.
• There is corruption in the installation of Microsoft Office.
• There are some changes in query and structure.

In the second part of this post, we come up with 4 efficient solutions on this issue for you. Without wasting more time, let’s dive into it right now!

MiniTool ShadowMaker TrialClick to Download100%Clean & Safe

How to Fix Download Did Not Complete Power Query on Windows 10/11?

Fix 1: Disable Background Refresh

Background refresh enables you to keep your queries up to date even when you are working on other files. However, constant refreshing can revert your data to its original forms. Disabling them might help you to complete the query.

Step 1. Click on a cell in the workbook and click on Data on the top taskbar menu.

Step 2. Under Quries and Connections, click on Refresh All and select Connection Properties from the drop-down menu.

Step 3. Under the Usage tab, uncheck Enable background refresh and hit OK to save the changes.

Fix 2: Unprotect and Protect Your Sheet Again

If you have enabled the Protect Sheet feature in your worksheet, you can consider disable this feature and then enable it again. Follow these steps:

Step 1. Open the problematic worksheet.

Step 2. Under the Review tab, hit Unprotect Sheet, enter the right password, and hit OK.

Step 3. Once the worksheet is unprotected, restart it. Go to Review > Protect Sheet to protect the sheet again.

Fix 3: Update Microsoft Office

Make sure your Microsoft Office is up-to-date. Follow these steps to check for if there is any updates available.

Step 1. Open your problematic worksheet.

Step 2. Click on File on the top-left corner and hit Account.

Step 3. Under Update Options, hit Update Now.

Fix 4: Repair Microsoft Office

Microsoft Online Repair can help to fix any issues with corruption on the Excel app. Here’s how to perform an online repair:

Step 1. Press Win + R to open the Run box.

Step 2. Type appwiz.cpl and hit Enter to launch Programs and Features.

Step 3. Scroll down to locate Microsoft Office, right-click on it, and select Change.

Step 4. Tick Online Repair and hit Repair to start the process.

Microsoft Office Repair Tool | Repair an Office Application

Some free Office repair tools are provided to help you repair Microsoft Office or Microsoft 365 applications and repair corrupted Office files on Windows 10/11.

Read More

Final Words

Now, you can continue to handle your data without download did not complete while using Power Query. Last but not least, don’t forget to make a backup copy of your Excel file with MiniTool ShadowMaker. Appreciate your time!