Is it possible to insert a Excel spreadsheet into a number of drawings so that when the original spreadsheet is updated, it updates also in any drawings where it was used?
yes, but I would be careful with that option as there have been bugs related to it... we abandoned that method because of them so I'm not sure if they still are out there.
Method: Select Insert > Object, select the "Create from File" option and the file with "Browse..." and check the box that says "Link"
Thanks Paul for both the method and the warning. It is good to know about that possible issue.
I'm inserting the xls successfully, but I can't resize it. If I double click on it, Excel opens and there is nothing to do.
Single-Clicking the spreadsheet in the drawing will select it and present grab handles at the corner for resizing. However, this only scales your view. It does NOT change the portion of the spreadsheet that is viewable.
SW2013 SP3 does not seem to provide an obvious method to modify the viewable cells shown in the drawing.
No. SW 2012 doesn't let me to edit the embebed xls. It opens the xls externally. Only does it with linked xls, not with unlinked xls.
I stopped using this function a few years ago for the same reasons as posted.
I couldn't get the spread sheet when it was linked to update correctly and also couldn't format the linked spread sheet.
I haven't even bothered looking to see if was fixed, nice to see a couple of years later it's still not fit for purpose.
Ah well 2020's not far away (but don't hold your breath).
Mark (SolidWorks 2015 sp1)
What's your workaround for linking spreadsheets to drawings?
I don't use linked spread sheets.
I just embed a spread sheet into the drawing and update manually. (By clicking to open the spread sheet in the drawing).
I tried it and linked the embeded spreadsheet to the original spreadsheet that drives all tables.
Other way I've tried is to insert linked spreadsheet and with some juggling I got my spreadsheet linked. I need to remember NOT to update linked documents when opening drawing.
I am trying to do this as well but find that often a portion of what I am pasting into Solidworks does not show. I can't seem to change the extent of how much data is shown in Solidworks, it simply changes the scaling of the data in Solidwork instead of expanding the amount of data shown. Do you have this issue? Have to got a work around?
SW has always functioned a bit oddly with inserted spreadsheets. When you insert a spreadsheet (Insert / Object / created from file) frame around the inserted worksheet will indeed just scale the inserted object. You need to double-click the inserted worksheet to switch in to edit mode. In this mode you can drag the border (just like discussed above) and this time the view will not scale. Once you have the area of the worksheet showing as you desire click anywhere outside of the worksheet window to exit the edit mode. Your inserted worksheet should now show up just as you edited it.
I have tried the procedure you suggested, however, it does not re-size correctly.
The image below shows the data I selected to copy from excel
The image below shows the result of the paste into Solidworks. (Notice that Right hand side of content is not showing)
The result after trying to expand the window. I double clicked in the excel data to activate it and then re-sized the window while it was activated. After re-sizing and then clicking out of the excel data the result is what you see below.
It should work as other have described, and this is the way I got it to finally work.
This is how I re - size the Excel sheets. Double click file to open up
Drag the little square box at the bottom of the sheet up or down to re - size.
Or drag the square box at the right / left hand side to make sheet longer.
Click out of sheet when finished.
That is what I tried to do but my result was not the same as yours. I will try again but fear I may have no luck. Others who I currently work with have said this is an issue they have had for many years with no luck on a solution so far.
When in your drawing did you try going.
Insert -- Object --- (select) Create from file -- Browse ( to spread sheet) -- ok.
Also do not have the 'Link' option checked as this won't allow you to double click the file to open.
I will have to try this method. I simply did a ctrl c of the cells in excel and then a ctrl v in Solidworks. I did not link to the spreadsheet.
If you need to have the spread sheet linked, then what you would need to do to have additional cells show is delete the original and insert the updated spread sheet with the added columns. I expect you would need to do this every time you added or deleted columns.
This is why I don't have the link checked.
Forgot to add a couple of screen shots of how it looks.
Original spread sheet
I then delete this off the sheet and reimport the modified spread sheet.
This is the only way I could get a Linked spread sheet to work, so when I import a spread sheet I don't check the Link option.
Retrieving data ...