Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Wednesday, October 4, 2017 10:28 PM
Just this week my users started experiencing problems opening Microsoft Query .dqy files which we've used for years to query our DB2 database. The query starts by prompting for starting and ending dates to establish a date range filter for the query.
This problem is happening on both Windows 10 and Windows 8.1 workstations and it occurs with every .dqy file we try to open/launch.
The problem manifests itself by displaying the following error message any time someone tries to open a .dqy file: "Microsoft Excel has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."
I found the corresponding message in Event Viewer as a result of this crash:
Faulting application name: EXCEL.EXE, version: 16.0.8431.2079, time stamp: 0x59b25e0b
Faulting module name: EXCEL.EXE, version: 16.0.8431.2079, time stamp: 0x59b25e0b
Exception code: 0xc0000005
Fault offset: 0x00000000018cac6c
Faulting process id: 0x28b4
Faulting application start time: 0x01d33d5ec09f4986
Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE
Faulting module path: C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE
Report Id: 00e78261-a952-11e7-840a-001fb5240221
Faulting package full name:
Faulting package-relative application ID:
I've tried a number of recommendations I've found on the web, tweaking Add-In and Trust Center settings in Excel - nothing worked - until today, when I rolled back Office 365 to version 16.0.7967.2161 on a Windows 10 computer.
Please note - my users insist this problem was not happening last week. I checked another computer which hasn't had it's Office updated yet (it is using version 1707 (Build 8326.2076)) and the user was able to launch and use .dqy files on her computer, so this is the version I will be rolling back to where necessary for users who use the .dqy files.
Is there a better, more permanent fix for this problem?
All replies (3)
Thursday, October 5, 2017 6:00 AM
Dear Rochelle, I will recommend this thread to you: https://social.technet.microsoft.com/Forums/lync/en-US/10b6ecfc-e837-4ed9-b800-6e353f8a6cb8/excel-2016-exception-code-0xc0000005-offset-0x001a0dd3?forum=Office2016ITPro
Don't forget to share the result.
Good Luck!
Thursday, October 5, 2017 5:24 PM
Rolling back to a previous version fixed my problem - for now - until Microsoft recognizes and fixes this bug.
Thursday, October 5, 2017 8:59 PM | 1 vote
Note: I upgraded my Office 2016 to Version 1708 (Build 8431.2094) and this bug still exists - Excel is still crashing when trying to open .dqy files.
So, to be clear - there is no problem opening .dqy files with Excel version 1707 (Build 8326.2076), but there is a problem with 1708 (8431.2079) and 1708 (8431.2094).