External Spreadsheet tab recoginition

[johnlahring]

I am using an external spreadsheet to drive my model expressions. Is there a way to specify a different tab on the spreadsheet to use? Or does NX only recognize the first tab of a spreadsheet?

 

[JohnRBaker]

How are you connecting to this 'external' spreadsheet from within NX?

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

 

[johnlahring]

Through Tools, Expressions, Function button, then picking the spreadsheet from a folder and typing in the cell.

 

[cowski]

When you type in the cell address use the full reference <sheet name>!<cell address>.

So if you are referencing cell C5 on Sheet2, you would type in Sheet2!C5.

www.nxjournaling.com

 

[johnlahring]

Thanks John and cowski for the help.