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.
Bookmarks