This problem has only occurred since updated to Excel 2016 from 2010.

I click "edit design table", the window opens within Solidworks, I add a configuration, click outside the window to save, but the window simply closes and does not generate a new configuration. I open the design table again, and the newly added configuration disappears.

Really not sure what could be causing this.