I compiled my spreadsheet (version 1) into an exe file and given to my end user to input the data.
A newer version (version 2) with some changes requested by the end user to the spreadsheet.
How can I provide them with an updated version without losing their data since day one they have used it?
If they open an XLSC save file with the newer EXE version 2, they will still see their saved workbook (version 1).
Some customers solve that problem by allowing users to export their data to a third workbook file (not protected). However, you have to write VBA code to export and import user data. Some customers also let users copy their old data from workbook version 1 to workbook version 2 using the clipboard.