Bug #67468 MySQL for Excel cannot be installed because installer does not recognize VSTOR
Submitted: 4 Nov 2012 15:58 Modified: 15 Feb 2013 15:22
Reporter: Florian Conrady Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S1 (Critical)
Version:5.5.28.3 OS:Windows (XP Service Pack 3)
Assigned to: CPU Architecture:Any
Tags: MySQL for Excel, mysql installer, Visual Studio Tools for Office Runtime

[4 Nov 2012 15:58] Florian Conrady
Description:
Hi,

the installation of MySQL for Excel 1.1.0 fails because the MySQL installer does not detect the presence of Visual Studio Tools for Office 2010 Runtime (VSTOR). After opening the MySQL installer and checking the box for MySQL for Excel under Applications, I get to the Check Requirements window. There the installer prompts me to install VSTOR, I press execute and a pop-up opens asking me to either repair or uninstall VSTOR. I click repair, a number of files are installed and it says that VSTOR was successfully repaired. Back in the Check Requirements window the box for VSTOR remains nevertheless unchecked and I am again asked to install VSTOR.

The same problem was described by someone else in the forum:
http://forums.mysql.com/read.php?169,563914,563914

I tried two more things which did not help: 
- I uninstalled and reinstalled the entire MySQL.
- I uninstalled and reinstalled VSTOR outside of the MySQL installer.

Thanks
Florian

How to repeat:
Try installing MySQL for Excel using the MySQL installer.
[5 Nov 2012 17:30] MySQL Verification Team
installing

Attachment: mysql-excel.png (image/png, text), 84.58 KiB.

[5 Nov 2012 17:31] MySQL Verification Team
install sucess

Attachment: mysql-excel-install-sucess.png (image/png, text), 73.81 KiB.

[5 Nov 2012 17:33] MySQL Verification Team
Please see the 2 prior screen-shots, you failed in that install position?. Thanks.
[6 Dec 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[9 Jan 2013 23:57] Ed Greenbank
initial screen - pressing execute downloads and installed the missing feature initially

Attachment: XPsp3_1.png (image/png, text), 72.99 KiB.

[9 Jan 2013 23:58] Ed Greenbank
Even when installed, same screen as before returns. Pressing Execute just takes us to the modify screen for visual studio tools

Attachment: XPsp3_2.png (image/png, text), 166.87 KiB.

[10 Jan 2013 0:00] Ed Greenbank
as per above screenshots there is no way past this as the installer will never register than visual studio tools has in fact been installed. I showed my start menu to demonstrate that I do have Office 2010 installed. I am on XPSP3 with all updates and .NET 4 installed.
[10 Jan 2013 0:02] Ed Greenbank
The sole reason I downloaded this was to get the excel add on, so simply going without this is not a viable fix. I understand the install will work fine if I just untick the requirement to install the Excel feature.
[29 May 2013 5:32] Chandra Sekhar Kakarla
As Ed Greenbank, said
"Install will work fine if I just un-tick the requirement to install the Excel feature" from the custom installation option.

But putting some light on this Issue, why excel extension for mysql(Visual Studio Tools for Office 2010 Runtime Excel extension) is not detecting properly will help the users.
[29 May 2013 5:32] Chandra Sekhar Kakarla
As Ed Greenbank, said
"Install will work fine if I just un-tick the requirement to install the Excel feature" from the custom installation option.

But putting some light on this Issue, why excel extension for mysql(Visual Studio Tools for Office 2010 Runtime Excel extension) is not detecting properly will help the users.
[2 Sep 2013 2:31] Zhaoyang Wang Wang
I meet the problem too. It seems that no one knows how to solve the problem.
[3 Oct 2013 15:50] Duane Mengo
We are also experiencing the same issue.  Is there a resolution?
[25 Nov 2013 5:43] Rajesh N
Is there any solution to overcome this issue.
[25 Mar 2014 12:48] paya tada
Hi, I have the same problem: unable to install mysl for excel beause of visual studio bug. Any solution?
[2 Oct 2014 23:05] Walter Hopkins
I am stuck here too.
[3 Nov 2014 20:38] Mohammad Diab
Workaround: to download the specific package from http://dev.mysql.com/downloads/windows/excel/ and not use the Windows Installer for Excel.
[1 Sep 2017 14:05] Ramya Iyer
use this link to download it explicitly without using msi installer:
https://dev.mysql.com/downloads/file/?id=470616
This worked fine for me...hope it helps