Excel spreadsheet linking problem
I am using Windows 7 (64 bit) OS , Inventor Pro 2012 (64 bit) and Excel 2007 and cannot get spreadsheets to link to Inventor models or assemblies. I have followed the instructions of a number of tutorials for linking spreadsheets to Inventor files but nothing works. When I select LINK in the Parameters dialog box all I get is the name of the file chosen for the link but none of the spreadsheet parameters show up. Is there something missing in my installation that would cause this problem ? I am not using the Vault or network licensing.
Re: Excel spreadsheet linking problem
Didn't you post this question on another forum?
Didn't I ask you at attach the Excel spreadsheet file?
It is not possible for anyone to answer your question without the file.
2 Attachment(s)
Re: Excel spreadsheet linking problem
Yes I did post on another web site. I have posted on quit a few sites trying to get my problem resolved. I have not responded until now because I was having trouble getting the log in program to accept my ID and Password.
I am using Windows 7 (64 bit) OS , Inventor Pro 2012 (64 bit) and Excel 2007 and cannot get spreadsheets to link to Inventor models or assemblies. I have followed the instructions of a number of tutorials for linking spreadsheets to Inventor files but nothing works. When I select LINK in the Parameters dialog box all I get is the name of the file chosen for the link but none of the spreadsheet parameters show up. Is there something missing in my installation that would cause this problem ? I am not using the Vault or network licensing and I have tried linking with virus protection turned off.
After I link the spreadsheet file to the Inventor part I get the following in the Parameters window shown in the attachment. Notice there are no Parameters listed from the spreadsheet file. I am attaching the spreadsheet file but i am not able to attach the Inventor file which is nothing but a simple square box.
2 Attachment(s)
Re: Excel spreadsheet linking problem
The first thing I noticed was that you have not defined any values or unit types in the spreadsheet. Without seeing the part file, it is hard to know how you have set that up as well. I created a simple box, and was able to link the parameters from your excel sheet successfully once the values were defined. When you link your excel file, make sure you chose A2 as the starting cell.
1 Attachment(s)
Re: Excel spreadsheet linking problem
Sent you the wrong file. Attached the right one this time. The spreadsheet and inventor files are from a YouTube video tutorial that seemed to work in the video. Yes I tried checking A2 in the Parameters box but that does not correct the situation. Have also attached a picture of the Parameters box after I tried to link. You will notice there are no parameters listed, only the file name of the linked file.
Re: Excel spreadsheet linking problem
Nothing attached other than the excel file. You can save a lot of time by attaching a part you have created and tried to link to so that we can look at it in more detail.
Thanks.
Re: Excel spreadsheet linking problem
How do you expect me to send you the part file to look at when the software running this site does not allow attaching .prt files. You can look at the part I am trying to use by going to "http://www.screencast.com/t/MPkQeZduU" web sit. I am trying to follow the example excel and part file shown in that video tutorial. I already attached the Excel spreadsheet and a picture of the Parameters window in the linked part file that I get after attempted linking in a previous meaasge. There are no Parameters for you to check out in the part file at this point. The part is just a simple square rectangle. For some strange reason my Inventor 2012 will not read the parameters setup in the Excel file and display them like the example shows in the tutorial. I have used AutoCAD ever since version one and have linked files in the past so I know a little bit about linking in previous versions. But, I am new to Inventor 2012 and I am trying to find out if anybody else has experienced this problem and what they did to correct it. Is this a bug in 2012 ? Is there a setting in Inventor 2012 that allows or disallows linking to external spreadsheets ? Do I have a crupted file in my setup ? I have been working with Inventor support personel for over a week now and I am getting very frustrated. So far they don't seen to know what is causing the problem. They tell me that they are able to get the part file to link on there system and display the parameters in the Excel file and show up in the Parameters Window so why doesn't my set up work like that ?
Re: Excel spreadsheet linking problem
Quote:
Originally Posted by
tlepird2925761
How do you expect me to send you the part file to look at when the software running this site does not allow attaching .prt files.
Inventor creates *.ipt files, not *.prt files (are you a former Pro/E user?).
In Windows Explorer right click on the *.ipt filename and select Send to Compressed (zipped) Folder and attach the resulting *.zip file here.
Quote:
...and have linked files in the past so I know a little bit about linking in previous versions
Can you reproduce the issue in 2012 with that same Excel file that you linked previously?
Originally you attached the wrong xls file here - are you sure you aren't trying to link to the wrong file?
Have you installed SP1 for 2012?
Re: Excel spreadsheet linking problem
If you will look at the list of attachments, you will see that the last one of the acceptable file types is *.zip. If you want to eliminate the possibility that the problem lies in the part file, then you may try that option.
That being said, I don't believe that is your issue now. The problem may stem from a faulty Inventor-Excel handshake or translation. I have see this occur in several Inventor installations, and the only fix I have found (sadly) is a complete un-install and re-install of Inventor AND Excel (the entire office suite if possible). Once the un-install is successful and the system re-booted, Excel must be installed first, and run and checked for a successful installation. The system must be re-booted again, and then Inventor can be installed.
I always install and run Excel first, and on a new or clean system if at all possible. The handshake failure still occurs on occasion and this is the only process that has worked for me.
Hopefully the dudes at Autodesk can find a less painful and time-consuming alternative. If they do, please let us know.
Good Luck!
Re: Excel spreadsheet linking problem
Re: Excel spreadsheet linking problem
Do not have ZIP program to compress files. Do not believe the problem is in the part file because the part file works on other systems using Excel 2003 just not Excel 2007 on my system. I agree that it looks like the problem is in the handshake between the two programs but what to do about it ? I have tried re-installing Inventor and Excel but it still doesn't work. I read recently on an Inventor blog site, some guy posted a solution involving the editing of the Registery files on 64 bit systems to solve the problem. According to him, Excel 2007 and Inventor 2012 in a 64 bit enviroment need certain changes made in the Windows system Registery to allow for communication between them. Even though the process he discribes in the blog looks a little bit complicated, I think I will try it to see if it works. Thanks for all of your inputs.
Re: Excel spreadsheet linking problem
Quote:
Originally Posted by
JD Mather
Inventor creates *.ipt files, not *.prt files (are you a former Pro/E user?). .........Yes I am a former Pro/E user but that is not why I typed *.prt. It was a type -O. The sarcasam really helps.
In Windows Explorer right click on the *.ipt filename and select Send to Compressed (zipped) Folder and attach the resulting *.zip file here. Do not have A program to Zip files.
Can you reproduce the issue in 2012 with that same Excel file that you linked previously? ....The Inventor 2012 part file works on another system using Excel 2003.
Originally you attached the wrong xls file here - are you sure you aren't trying to link to the wrong file? ........I am sure I am linking to the correct file.
Have you installed SP1 for 2012?
.........Yes
Sorry you miss read my quote about linking experience with Autocad and Excel. I did not say I was experienced with Inventor 2012 and Excel 2007. I am new to Inventor 2012 and only recently install Excel 2007. The last time I used linking it was between Autocad 2000 and Excell 2000 which worked fine. A lot has changed in both of these programs over the years. The sarcasam really helps. Thanks for your inputs but I don't think I need them I the future.
1 Attachment(s)
Re: Excel spreadsheet linking problem
Actually you do have a zip program. It is built-in to Win7:
RMB on any file/folder and you will see menus and options similar to the attached.The first item in the "Send to" menu is "Compressed (zipped) folder"
Re: Excel spreadsheet linking problem
My bet is the the spread sheet does not have the first two columns populated (a most, you can not have anything before on your spread sheet) by the parameter name and value, there is probally an issue with either of these columns. Or you have a bad parameter, you may have included an unusable character, like *)
Re: Excel spreadsheet linking problem
Quote:
Originally Posted by
David Gaskill
.... you can not have anything before on your spread sheet...
Sure you can.
YOU tell Inventor the start cell. It can be anywhere as long as proper convention is then followed.
Variable_name, value, units, comments
When Inventor hits a blank cell (other than units or comments) after designated start cell it will stop reading parameters. If units is blank Inventor assigns document units.
Re: Excel spreadsheet linking problem
Quote:
Originally Posted by
tlepird2925761
I am using Windows 7 (64 bit) OS , Inventor Pro 2012 (64 bit) and Excel 2007 and cannot get spreadsheets to link to Inventor models or assemblies. I have followed the instructions of a number of tutorials for linking spreadsheets to Inventor files but nothing works. When I select LINK in the Parameters dialog box all I get is the name of the file chosen for the link but none of the spreadsheet parameters show up. Is there something missing in my installation that would cause this problem ? I am not using the Vault or network licensing.
Hi,
Was the problem solved ?