Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Edit via spreadsheet not working

17 REPLIES 17
Reply
Message 1 of 18
blswartz
1614 Views, 17 Replies

Edit via spreadsheet not working

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...

17 REPLIES 17
Message 2 of 18

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

 

 

Message 3 of 18

I will check that, although I have opened task manager to see if EXCEL.exe is running, and it is not.

 

Thank you.

Message 4 of 18
jletcher
in reply to: blswartz

Message 5 of 18
blswartz
in reply to: jletcher

Thank you, I have done that.  It fixed a few of our engineers, but 2 of them are still having the problem.

Message 6 of 18

No hidden dialogue boxes come up Smiley Frustrated

Message 7 of 18

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

Message 8 of 18
jletcher
in reply to: blswartz

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.....

Message 9 of 18

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.

Message 10 of 18
blswartz
in reply to: jletcher

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"

Message 11 of 18
blswartz
in reply to: blswartz

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.

Message 12 of 18
jletcher
in reply to: blswartz

When you ran repair did you redo the regedit?

Message 13 of 18
blswartz
in reply to: jletcher

No, I can do that. Thanks for the suggestion.

Message 14 of 18
blswartz
in reply to: jletcher

unfortunately, no change.

Message 15 of 18
kstate92
in reply to: blswartz

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.

KState92
Inventor Professional 2020
AutoCAD Mechanical 2022.0.1
Windows 10 Pro 64 bit - 1903
Core i7-8700 32 GB Ram
Quadro P2000
Message 16 of 18
blswartz
in reply to: kstate92

At some point they were upgraded from 2010, but as far as I can tell, 2010 has been uninstalled (maybe registry fragments out there?)

Message 17 of 18
kstate92
in reply to: blswartz

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?

KState92
Inventor Professional 2020
AutoCAD Mechanical 2022.0.1
Windows 10 Pro 64 bit - 1903
Core i7-8700 32 GB Ram
Quadro P2000
Message 18 of 18
naresh_kalyan
in reply to: blswartz

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

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report