Hello. Let me start off by saying I'm not an engineer, I'm not very familiar with the Autodesk/Inventor software. I am an IT professional trying to solve this problem for one of our engineers. The Edit via spreadsheet option does not work, it will not call up Excel, although it believes that it does. The computer is running Win7 Ultimate sp 1 64, Office Home and Business 2010 sp1 32, Inventor 2012 sp2. The software (windows, office) is up to date, I have done the registry edit that other sites have mentioned, and I'm completely out of ideas.
I will bring up (please forgive me if my vocabulary isn't exact) an .ipt, right click on Table, click on Edit via spreadsheet. I will get a circle for a cursor for a moment as if it were processing, then nothing. I right click on it again, and just get the How To option, so it believes Excel is open when it is not.
I have no idea what to try next, and there doesn't seem to be any other fix out there other than the registry hack, which I've already done.
Thank you for any thoughts on this issue...
Hi blswartz,
Is it possible that excel is opening off screen, as mentioned at this link:
http://inventortrenches.blogspot.com/2011/01/missing-dialog-box.html
I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com
I will check that, although I have opened task manager to see if EXCEL.exe is running, and it is not.
Thank you.
Had this issue look at this to fix.
http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=14079866&linkID=9242018
Hi blswartz,,
Besides the registry edit and a dialog coming up off screen, the other common issue (going from memory) would be user profile related.
If you log in as the system admin and run Excel once, and then log in as the user, does this fix it?
Also if you run Inventor as the system admin and try to Edit Via Spreadsheet does it work?
I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com
Sorry did not read very good on your post. Have you gone and look at the other two and made sure all of the Wow6432Node are gone?
When I did the ones here on one machine I missed one.....
I have tried (and just did again, per your suggestion) to do this both as the user and as an administrator. Same issue in both profiles. Interesting thing I noticed though, which goes along with the idea the Inventor believes Excel actually opened, is after I hit ESC, then right click Table, it brings up the option to Edit Again via spreadsheet.
I ran a batch regedit for all the computers that couldn't open excel, it worked for all but 2. I have since done those 2 seperately, made sure they had full permission to that section of the registry, and have double and triple checked.
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}] @="Microsoft Excel Application"
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\Implemented Categories]
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\Implemented Categories\{000C0118-0000-0000-C000-000000000046}]
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\InprocHandler32] @="ole32.dll"
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\InprocServer32] "Assembly"="Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" "Class"="Microsoft.Office.Interop.Excel.ApplicationClass" "RuntimeVersion"="v2.0.50727"
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\InprocServer32\14.0.0.0] "Assembly"="Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" "Class"="Microsoft.Office.Interop.Excel.ApplicationClass" "RuntimeVersion"="v2.0.50727"
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\LocalServer] @="C:\\PROGRA~2\\MICROS~1\\Office14\\EXCEL.EXE /automation" "LocalServer"=hex(7):78,62,27,42,56,66,21,21,21,21,21,21,21,21,21,4d,4b,4b,53,\ 6b,45,58,43,45,4c,46,69,6c,65,73,3e,56,69,6a,71,42,6f,66,28,59,38,27,77,21,\ 46,49,64,31,67,4c,51,20,2f,61,75,74,6f,6d,61,74,69,6f,6e,00,00
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\LocalServer32] @="C:\\PROGRA~2\\MICROS~1\\Office14\\EXCEL.EXE /automation" "LocalServer32"=hex(7):78,62,27,42,56,66,21,21,21,21,21,21,21,21,21,4d,4b,4b,\ 53,6b,45,58,43,45,4c,46,69,6c,65,73,3e,56,69,6a,71,42,6f,66,28,59,38,27,77,\ 21,46,49,64,31,67,4c,51,20,2f,61,75,74,6f,6d,61,74,69,6f,6e,00,00
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\ProgID] @="Excel.Application.14"
[HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046}\VersionIndependentProgID] @="Excel.Application"
Are there any add-ins in Excel that should be in there? I'm kind of grasping now, but don't know what direction to go. If I had to guess, I would say it's more a problem with Excel than Inventor, but that's just my gut feeling. I ran a repair in Excel but made no difference.
Did / does the two affected computers have any Autodesk Beta / Demo / Student software installed, or remnants (folders, reg entries) thereof? This is also a grasped straw.
At some point they were upgraded from 2010, but as far as I can tell, 2010 has been uninstalled (maybe registry fragments out there?)
Maybe, but it's a long shot. All I can think of is check that the two installs are pointing to the correct Design Data folder, in case what they are editing has threads and needs to access the Threads.xls file. Check at Tools > Options > Application Options > File tab (this is 2010, so it may have changed). Also maybe it's something with the Excel version or file format (xls / xlsx) or vba security settings?
Hi evryone,
I do face the same challenge while working on IN 2011 with Windows 64 bit. Did anyone have precise answer for this question? Please let me.
Regards
NKalyan