After I recently and erroneously mentioned the Solid Edge Variables to Spreadsheet Link along with ST8’s new features, I decided this would be a good time to learn how to do this myself, and find out just how well it works.
Solid Edge Variables Spreadsheet Link Process
- Open a spreadsheet, select a cell, and use the Copy command to copy the cell to the Clipboard.
- Open the Solid Edge Variables table
- Pick the variable value cell that you want to link.
- Pick Paste Link from the context menu.
The link will be applied, and the values adjusted, immediately. Refer to the following images.
Basic Station offset spreadsheet: Pick, right-click, and copy.
Solid Edge Variables table: Pick the cell, right-click, Paste Link.
Solid Edge Variables Table again: note the link automatically populates in the Formula column.
Spreadsheet update: as soon as the cell updates in the spreadsheet, Solid Edge responds accordingly.
Ok, that was freakin cool. I doubt that Siemens PLM could have made that easier, or more straight-forward. I like the instant update, and not having to save the spreadsheet first.
Now all I have to do is stitch all this into Solid Edge.