Hi Cap, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues.
Please let me know by replying to me here so that I can help you further.
Thank you for writing back with that information. So the affected file here, the one with lost data, is the .CSV file, correct? So in the CSV file, you added charts and macros and when Excel crashed, those data you added to the CSV file was lost.
Is that correct?
Thank you for writing back with that information.
Based on your described scenario, the problem was with Excel -- but it is caused by the CSV file that you choose to work with.
Please let me explain.
The CSV data type is a comma delimited type of data, and it cannot hold most of Excel formatting, embedded objects like charts, and especially macro. For Excel to SAVE the macro in the file, you need to choose the file type called Macro Enable Workbook with XLSM extension.
Thus, based on your scenario, Excel could have frozen after several saving attempts of the CSV file while eliminating those unsupported objects like charts, marcos and other formatting.
If you try to create a simple CSV file containing names, and then re-open it in Excel and try to change the formatting, like making rows higher or columns wider, when you choose to save it as a CSV, after closig and opening the file again, those formatting will be lost since they are NOT SAVED along with the CSV.
Therefore, to answer your question, the objects are missing when Excel crashed because the file is a CSV file. Those information (formatting and objects like charts and macros) are eliminated during the saving process.
And your Excel could have crashed due to the nature of data you added to the CSV file.
Unfortunately, since the original file is a CSV file, no formatting and additional embedded data will be saved with it. Therefore, if you go to the AutoRecovery folder location to locate earlier saved versions of the file, you will still get the plain CSV data, no charts, no macros.
If you want to save charts in your Excel file, you need to use the regular XLS or XLSX file format. And if you want to save a macro along with the Excel file, it will be an Excel Macro-Enabled Workbook with a file extension of .XLSM.
I hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!
If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.