I am running excel 2010. In the past I have captured data from another excel file through From Other Sources on the data menu.

Today I get an error when I select From Other Sources -> From Microsoft Query -> Excel Files*

After clicking the Excel Files and then OK, I get the following error:

Microsoft Query Has Stopped Working
A problem caused the program to stop working correctly. Please close the program.

I have tried this in regular mode and safe mode and get the same message.

I have also gone to Programs and Features -> Microsoft Office Professional Plus 2010 -> Office Tools and repaired MS Query.

None of these actions solved the problem.

How do I fix this error?

Thank you.