×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Variables in Excel

Variables in Excel

Variables in Excel

(OP)
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.

RE: Variables in Excel

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.

RE: Variables in Excel

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

Hope this helps.

RE: Variables in Excel

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

RE: Variables in Excel

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources