Forum Discussion
POWER QUERY NOT WORKING !!
I’m using Office LTSC 2024, In Power Query, when I try to load data from another Excel file (or even the same workbook), I get the error: "Microsoft Excel couldn't load a necessary component. It mig...
This is not a general PQ bug; it’s a known limitation/compatibility problem in LTSC 2024 when loading Excel files via PQ. Using an external copy, 64-bit Office, and re-registering PQ DLLs usually resolves it.