Cyril S
Industrial
- Oct 31, 2023
- 3
Hello everyone,
I thought I could share this tip.
TLDR : Cell format doesn't correctly show up in the Part Family Excel Sheet, you need to check manually, especially if you copy/paste from a regular Excel.
When creating/updating parts in a Part Family, I got the error "The specified string contains a syntax error".
I tried multiple solutions (changing cell format, checking the 3D etc.)
The problem was the cell format, but changing it to "number" via the top menu didn't work.
I had to visually search for the cells with the little green triangle in the corner, and the convert to number via the pop-up menu (see picture, it's in French, but you'll get the point).
I found that re-typing all the numbers by hand also fixes the problem.
I thought I could share this tip.
TLDR : Cell format doesn't correctly show up in the Part Family Excel Sheet, you need to check manually, especially if you copy/paste from a regular Excel.
When creating/updating parts in a Part Family, I got the error "The specified string contains a syntax error".
I tried multiple solutions (changing cell format, checking the 3D etc.)
The problem was the cell format, but changing it to "number" via the top menu didn't work.
I had to visually search for the cells with the little green triangle in the corner, and the convert to number via the pop-up menu (see picture, it's in French, but you'll get the point).

I found that re-typing all the numbers by hand also fixes the problem.