Vlookup and the value 3.25

[snichols]

Has anyone else ever had trouble with the value 3.25 and a vlookup in an ipart/iassembly spreadsheet. If I edit the spreadsheet after a member change it loses the cell reference, if I simply retype the 3.25 value into the cell everything goes back to normal. Then if I close the spreadsheet, do a member change and then go back in to edit it, it has again lost the reference. Anyone??

[snichols]

Has anyone else ever had trouble with the value 3.25 and a vlookup in an ipart/iassembly spreadsheet. If I edit the spreadsheet after a member change it loses the cell reference, if I simply retype the 3.25 value into the cell everything goes back to normal. Then if I close the spreadsheet, do a member change and then go back in to edit it, it has again lost the reference. Anyone??

[innovatenate]

Are you closing excel in-between edits to the family table?

[innovatenate]

Are you closing excel in-between edits to the family table?

[snichols]

Yes, The order is:

Edit via spreadsheet

Edit whatever is needed

Save and close the spreadsheet

change the member in the model

re-open the spreadsheet and voilà!

[snichols]

Yes, The order is:

Edit via spreadsheet

Edit whatever is needed

Save and close the spreadsheet

change the member in the model

re-open the spreadsheet and voilà!

[innovatenate]

I've heard of MS Excel locking files if the program is note shut down in-between edits. 

If you don't mind, could you share the files in question with me? I will enable an FTP site for you to transfer the data to. Look for an e-mail with access instructions to arrive shortly. 

Let me know if you have any trouble sharing the data.

Thanks,

[innovatenate]

I've heard of MS Excel locking files if the program is note shut down in-between edits. 

If you don't mind, could you share the files in question with me? I will enable an FTP site for you to transfer the data to. Look for an e-mail with access instructions to arrive shortly. 

Let me know if you have any trouble sharing the data.

Thanks,

[snichols]

I have uploaded the data, let me know if you need anything further. Thanks! 

[snichols]

I have uploaded the data, let me know if you need anything further. Thanks! 

[innovatenate]

I wasn't able to reproduce the issue. 

In Inventor 2015 Update 2:

1. Edit the Family Table in Excel
2. I had to edit the 3.25 value to be "=3.25" for the vlookup to solve correctly (I'm not sure why that is)
3. Close the excel spreadsheet
4. Save and update the table values and everything appears to be okay.
5. Even if I close, re-open, and then re-edit the table. It appears to be okay. 

I repeated the same test in Inventor 2013 SP2, and everything worked as well. I uploaded that model to the FTP site for your reference. 

I'm using MS Excel 2010 32-bit. Which version of Excel do you have?

Take a look again and let me know if that file still behaves the same on your machine. 

Thanks,

[innovatenate]

I wasn't able to reproduce the issue. 

In Inventor 2015 Update 2:

1. Edit the Family Table in Excel
2. I had to edit the 3.25 value to be "=3.25" for the vlookup to solve correctly (I'm not sure why that is)
3. Close the excel spreadsheet
4. Save and update the table values and everything appears to be okay.
5. Even if I close, re-open, and then re-edit the table. It appears to be okay. 

I repeated the same test in Inventor 2013 SP2, and everything worked as well. I uploaded that model to the FTP site for your reference. 

I'm using MS Excel 2010 32-bit. Which version of Excel do you have?

Take a look again and let me know if that file still behaves the same on your machine. 

Thanks,

[snichols · Accepted solution]

Adding the = before the 3.25 value solves the issue so I will make this my default work flow. Thank you for your time!

[snichols · Accepted solution]

Adding the = before the 3.25 value solves the issue so I will make this my default work flow. Thank you for your time!