Did you accidentally removed MySQL Excel Add-in for Excel? Are you trying to re-add it but getting errors? In this blog, I try to list some solutions regarding the re-installation of mysql-for-excel-1.3.8. The version of my Windows is 10 and I’m using Microsoft Office 365 16.0.
When you try to reinstall the Add-in, it might not be displayed in the Data tab of your Excel because it’s not properly installed.
Executing MySQL for Excel VSTO File
You can try running the VSTO file in Program Files (x86)/MySQL/MySQL For Excel 1.3.8/MySQL.ForExcel.vsto. It might add the Add-in with no problem. However, you might get the error below.
Name: MySQL.ForExcel
From: file:///C:/Program Files (x86)/MySQL/MySQL For Excel 1.3.8/MySQL.ForExcel.vsto
************** Exception Text **************
System.Deployment.Application.DeploymentDownloadException: Downloading file:///C:/Program Files (x86)/MySQL/MySQL For Excel 1.3.8/MySQL.ForExcel.dll.config did not succeed. —> System.Net.WebException: Could not find file ‘C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.8\MySQL.ForExcel.dll.config’. —> System.Net.WebException: Could not find file ‘C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.8\MySQL.ForExcel.dll.config’. —> System.IO.FileNotFoundException: Could not find file ‘C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.8\MySQL.ForExcel.dll.config’.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
— End of inner exception stack trace —
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.GetResponseCallback(Object state)
— End of inner exception stack trace —
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
— End of inner exception stack trace —
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.DownloadAddIn(TimeSpan timeout)
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()
Re-Adding or Re-Installing MySQL For Excel
Please follow the steps below to reinstall the Add-in,
- Uninstall MySQL For Excel through Control Panel
- Open Registry Editor
- Search for “MySQL.ForExcel” and delete any record that you find for MySQL for Excel
- Restart your computer
- Try to reinstall MySQL for Excel Add-in
- Open your Excel and hopefully you find MySQL for Excel in your Data tab