I was asked to modify a plan that is last called for a room that uses a table to design and edit it quickly, except that we are trying to edit two values,
the play does not follow and I have this message
Is it possible to guide me to remedy this problem, it's not me who makes the file Thank you
What do the circled values represent? What are the original values, and what values are you trying to replace them with?
PS: it would be nice to correct the word " Length " with its correct version " Length " with a U. This could prevent future mistakes, if it is not already the case here.
Someone has probably changed either the name of the dimension or the name of the sketch. Do a search in the filter of the creation tree to see if you find the sketch and then look in this sketch for the dimension " Ball length" If you can't find a rating with this name, the problem comes from there. → either you modify the Excel file to put the name of the dimension that exists in the sketch, or you rename the dimension in the sketch (the most logical for me)
If it is the sketch that has changed its name, you need to update the Excel table with the correct sketch name
As stated on the message, the problem is in the column header (column name) not in the added values. (cf @froussel If you can't identify the error in the header name, you copy and paste your table into another excel file for backup. You delete the part family and you recreate it automatically. And you compare and modify the values if you have any problems.
Hello Sirs, @Sylk The value in red was 8 I changed it to 7 as requested and corresponds to the length of the half-sphere
The value in green is that of the drilling, I have changed it from 9.2 to 8.8 but it does not change
I don't know about the nominations, I didn't make them myself. @Rems51 The format of the cell is standard @froussel Or could I rename the sides? Thank you all
In general, the easiest way to fix this kind of error is to delete the offending column in the Excel table... quit Excel... and to restart the room family table from the right click ...
Then re-select the value to be added in the Excel table.
A little tip (or reminder...) To view the Dimension Name more easily, In the Hide/Show menu click D1 Dimension Name:
The values entered in the Excel table are only raw data. If they cause a reconstruction error, it will only be visible under Solidworks with the function in error but nothing will appear in the part family...
@Maclane, it's just a question to make sure you don't miss an " obvious " point
That said, another question with the names of columns. If they were changed, the problem would appear every time the Solidworks file was opened, wouldn't it? It wouldn't know where to point its value (although with Solidworks, I wouldn't be shocked that it keeps values cached and waits for a rebuild!)
=> You got it all figured out... The problem can only be seen if you edit the part family... Worse, it is only when saving/closing that Solidworks displays this alert (at the risk of losing any changes made in the meantime). To also answer @sbadenis ... there is no need (although security obliges) to create a copy of the Excel file. Solidworks only takes into account sheet 1 (sheet1) of Excel, so it is quite reasonable to create a new tab on the same workbook to duplicate the data... To be safe, however, I advise to leave two rows and two columns blank on this " backup " sheet. (Solidworks only takes into account rows and columns contiguous to cell " A1 "...)
… It happens! (This is why the " Show unselected objects again" checkbox should always be checked each time the room family tables are opened. However, nothing is lost... with the Excel table open, double-click on the dimension to be added and it will be entered again in the table (in the last position)... (the formatting of the cell will be that of a hyper-link but this is a normal operation).
On the other hand, I wonder if your rating (here 7mm) is associated with each configuration (normally it will have to change color to go to " Pink ") here it looks like a " universal " rating for all configurations...
Erratum: if the " show/hide " option the name of the call numbers is not available, it means that you have not assigned specific names to them...
(the example is not very well chosen but I don't have access to my Solidworks right now).
Erratum n°2 (disregard erratum n°1): Click (disable) " Hide all types " to access the options for viewing the dimensions... (among others)
… Because if you hide everything, you can't see anything...
Note: Personally I strongly suggest that you name your dimensions clearly if you are working on a component intended to have several configurations... See to copy the name of the supplier's table if it is a commercial component...
@Sylk Finally I will need the " Strike through text" option