Power Query is one of powerful features in Microsoft Excel to help you handle large amount of data.
However, you might bump into some error while using this feature.
The download did not complete warning pop-up might prompt up.
In this post onMiniTool Website, we will show you how to solve this problem step by step.
Without wasting more time, lets dive into it right now!
However, constant refreshing can revert your data to its original forms.
Disabling them might help you to complete the query.
Step 1. select a cell in the workbook and click onDataon the top taskbar menu.
UnderQuries and Connections, click onRefresh Alland selectConnection Propertiesfrom the drop-down menu.
Under theUsagetab, uncheckEnable background refreshand hitOKto save the changes.
Fix 2: Unprotect and Protect Your Sheet Again
Step 1. kick off the problematic worksheet.
Under theReviewtab, hitUnprotect Sheet, enter the right password, and hitOK.
Once the worksheet is unprotected, restart it.
Go toReview>Protect Sheetto protect the sheet again.
Fix 3: Update Microsoft Office
Step 1.
Open your problematic worksheet.
Click onFileon the top-left corner and hitAccount.
UnderUpdate Options, hitUpdate Now.
Heres how to perform an online repair:
Step 1.
Typeappwiz.cpland hitEnterto launchPrograms and Features.
Scroll down to locateMicrosoft Office, right-choose it, and selectChange.
TickOnline Repairand hitRepairto start the process.
Last but not least, dont forget to make a backup copy of your Excel file with MiniTool ShadowMaker.
