Variables in Excel

[ksudavid]

I'm using an Excel document to control variables in a number of different SE documents. The advantage is to have one location to make changes rather than updating variable tables in a number of different assemblies and parts. Everything worked fine until I inserted a row in the top of my Excel spreadsheet. All the SE variables are now looking at the wrong cell in the Excel spreadsheet. Is there a setting or method to prevent this from happening? If my spreadsheet has to be perfect and unchangeable from the start then this feature is not as useful as I was hoping.

 

[Edgewise]

As far as I know there isn't a way around this.... if you find one please post it.

All I can suggest is that you leave yourself some buffer area around the data in your spreadsheet (extra rows and columns above and to the left respectively), that way if you need to add some information above (or beside) you have the columns available already.

If you need to get your SE variables looking at the proper cells again, just delete your row that you added. Everything should reference properly after that.

 

[fwc]

I've tried assigning a name to each cell in Excel before linking to Solid Edge.

Hope this helps.

 

[nemet]

Like fwc said, solid edge will link the the name of your cell, if you dont give names, it will ling referencing lines & columbs, so if you want to add variables without giving name to cell, you ll have to enter your new variables at the end of your spreadsheet

 

[iceman1]

My tip ist to have a seperate spreadsheet in your Excel-Document that is linked to Solid Edge. In the other spreadsheet you can store the date. With a little macro you can copy the value of the variables from the Datasheet to the linked sheet.
So you can format the datasheet as ypu like without changing the link information to Solid Edge

tschau

iceman1