I know the subject "Can't open excel file, maybe not install office excel" sounds like improper English but this is exactly the error message I'm receiving when I try to open my cable.xlsx in the Cable Wire Library Wizard/Excel spread sheet import.
Where I'm at with this - My VAR support has no idea what may be causing this. It's only happening on my workstation, not others. I've been the primary owner (admin) of this file and have never had an issue until recently. Nothing has changed as far as I know. I've uninstalled and reinstall EPDM and SolidWorks (2015sp3). I've tried resetting my Microsoft Office registry key. I've tried saving this cable.xlsx file from EPDM out to my desktop as a temp.xlsx and temp.xls file and opening from there. I've opened our existing cable.xml file and tried to save it out as a new cable.xlsx and still get the same error.
Nothing seems to work and I'm not getting anywhere with internet searching or VAR support. Short of re-imaging my workstation I'm hoping I can maybe get some other suggestions to try from you folks. Thanks in advance.
Rich
Thanks again Deepak. I had tried many if not all of the suggestions mentioned in the link you provided. None of these helped. Also, running the Microsoft Office repair option did not resolve it.
I finally found the solution by reinstalling all of the programs in question. I did a clean uninstall of Microsoft Office Professional 2010, SolidWorks 2015sp3 and EnterprisePDM 2015sp3. I then had IT reinstall Microsoft Office. The difference here was they installed version 2013, not the 2010 version I had. I don't believe this made the difference because everything was fine before with 2010. I then reinstalled SolidWorks from my admin image. I made sure I followed the SolidWorks KB solution (S-069490) for admin installation, otherwise my add-ins aren't loaded. I finally installed EPDM, and then did a get latest on our Library folder where our cable.xlsx file is stored. I'm now able to import this Excel file in the Cable Library Wizard without issue.
Since I had already done a clean uninstall/reinstall of SolidWorks and EPDM prior to uninstalling Microsoft Office and continued to receive the "Can't open excel file, maybe not install office excel" error message my guess is the Office/Excel installation became corrupt somehow. I don't know if it was just the Office reinstall, or the combination of things here.
Thanks again for your suggestions. In a case like this you never know what the trick is going to be.
Rich