Ever since we switched to Office 365, Excel embedded tables do weird things that I haven't found a fix for.
Example - I have an embedded table for a couple dimensions. I double click on it, then add a column. Then I expand the selection to include the column.
Seems normal so far.
Then I click away from the table to close it, and the spreadsheet snaps back to original sizing and cuts off my new column (which is there if you open it back up).
Weirder still... If I paste my data into a new excel file, and copy it back to Solidworks - Bam! Same cut off of my new column.
Running SW 2018 SP 5.