/build/static/layout/Breadcrumb_cap_w.png

Miscellaneous Question


Excel crashes on refreshing data.

05/09/2017 3788 views
In our environment we have Microsoft Office 2010 products except Outlook and Skype. Outlook and Skype are from Office 2016.

So, there started a problem with Excel 2010. When the user tries to "refresh" the data from the "data" tab, the excel crashes. According to the user, it all started after Outlook and Skype 2016 were installed.

What I tried so far;

1. https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2011/11/21/excel-crashing-look-at-your-com-add-ins-first/
From the above link, tried disabling com addins one by one and checking. No result so far.

2. Tried opening Excel in safe mode. No result. 

3. File-> right click-> open with (browsed the path of Excel.exe for Excel 2010) Not worked.

4. Editing the registry: Instead of OFFICE 16, I did OFFICE 14. But didn't work.

A) [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb, *.accdb)]
"Driver"="C:\\PROGRA~1\\COMMON~1\\MICROS~1\\OFFICE16\\ACEODBC.DLL"
"Setup"="C:\\PROGRA~1\\COMMON~1\\MICROS~1\\OFFICE16\\ACEODBC.DLL"

B) [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Text Driver (*.txt, *.csv)]
"Driver"="C:\\PROGRA~1\\COMMON~1\\MICROS~1\\OFFICE16\\ACEODBC.DLL"
"Setup"="C:\\PROGRA~1\\COMMON~1\\MICROS~1\\OFFICE16\\ACEODTXT.DLL"

C) [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)]
"Driver"="C:\\PROGRA~1\\COMMON~1\\MICROS~1\\OFFICE16\\ACEODBC.DLL"
"Setup"="C:\\PROGRA~1\\COMMON~1\\MICROS~1\\OFFICE16\\ACEODEXL.DLL"


Any Suggestions Please?

Thanks in advance.

0 Comments   [ + ] Show comments

Comments


Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ