Fix Power Query Data Loading Errors in Excel LTSC 2024
Question details
Users are experiencing errors when attempting to load data from workbooks using Power Query in Excel LTSC.
- Product
- Microsoft Excel LTSC 2024
- Device & OS
- Windows
- Scenario
- Loading data from the same or another Excel workbook using the Power Query feature.
- Observed behavior
- Excel displays errors such as 'Microsoft Excel could not load a necessary component' or 'Download failed', which persist even after performing an Office repair.
Ensure you have administrator privileges on your computer, as you will need to use the Command Prompt to re-register system components. Please save your work and close all active Excel instances before proceeding.
Remove Conflicting Access Database Engine Versions
Conflicting 32-bit and 64-bit Access Database Engine installations can disrupt Excel's Data Provider and cause missing component errors.
This issue often occurs after installing multiple Office versions or redistributable drivers. If Excel references the wrong provider due to a mismatch between 32-bit and 64-bit components, Power Query will fail to load data.
Click the Windows Start menu, type 'Control Panel', press Enter, and navigate to 'Programs and Features'.
Scroll through the list of installed programs to find 'Microsoft Access Database Engine' or 'Office Data Connectivity Components'.
If you are running a 64-bit version of Excel LTSC, look for any 32-bit versions of the database engine. Right-click the mismatched version and select 'Uninstall'.
Once the uninstallation is complete, restart your computer to ensure the system registry clears the old provider references.
Re-register the Power Query Mashup Engine DLLs
Manually re-registering the Power Query Dynamic Link Libraries (DLLs) via Command Prompt can restore the missing Microsoft Mashup Engine components.
Experience Reliable Data Management with WPS Office
Dealing with corrupted Power Query engines and conflicting registry components in Microsoft Excel LTSC can disrupt your workflow. Consider switching to WPS Office—a highly compatible, lightweight, and completely free alternative that handles complex spreadsheets effortlessly without bulky add-in conflicts.
Frequently Asked Questions
Why does the Power Query data loading error happen specifically in Excel LTSC?
Excel LTSC (Long Term Servicing Channel) uses a perpetual license with a static build of the Microsoft Mashup Engine. Unlike Microsoft 365, it does not receive continuous feature updates, making it more vulnerable to component mismatches when other database drivers are updated or installed over time.
Will the standard Office Repair tool fix the PQProxy.dll error?
Often, a standard Office repair will not fix registry issues related to conflicting 32-bit/64-bit Access Database Engines or deeply corrupted Mashup Engine DLLs. Manual re-registration via Command Prompt or the removal of conflicting engines is typically required.
What if I cannot find the Office16 folder in my Program Files?
The folder path depends on your specific installation type and architecture. If it is not in '\root\Office16', check 'C:\Program Files\Microsoft Office\Office16' or the 'Program Files (x86)' directory if you are using the 32-bit version of Excel LTSC.
What exactly does the 'regsvr32' command do?
The 'regsvr32' command is a built-in command-line utility in Windows used for registering and unregistering OLE controls, such as DLLs (Dynamic Link Libraries) and ActiveX controls, within the Windows Registry, enabling applications like Excel to locate and use them properly.
