Forum Discussion
Excel workbook remains corrupted after trying all repair options
Ideapad Laptop/Windows 10 Home version 20H2 Microsoft® Excel® 2016 MSO (Version 2109 Build 16.0.14430.20154) 32-bit Excel tab accidentally closed by action on another tab. Have tried all repair opt...
- Brilliant - thank you so much. To still have the data after all the time spent researching is a relief. You are so kind doing what you do to help people - thank you - Roger
Sorry - not for that file :'(
If it was saved on onedrive/sharepoint there may be a possibility to go back to a previous version (You'ld probably already tested that in case it was possible).
Possibly but unlikely a completely different program like BI appllications QlikView or Qlik Sense could read only the data and don't bother about crashed conditional formatting or similar. Qlik is just one possibility. microsoft Power BI is probably too close to Excel but may be worth trying. Also other BI programs that have the possibility to load directly from Excel files.
I have been in the same situation soo many times and started to use F12 (Save as) to add a timestamp to the file like every ten minutes.
Some times I also add a note on what I am working on at the moment, or what I am about to start to do so I have a version to go back to in case I would like to.
MyWork_231122_1248.xlsx
MyWork_231122_1252 to be newSumByCol.xlsx
MyWork_231122_1259.xlsx
MyWork_231122_1317 golden master.xlsx
MyWork_231122_1333 delivered.xlsx
Using a notation like YYMMDD the files will be sortable also by names.
If it was saved on onedrive/sharepoint there may be a possibility to go back to a previous version (You'ld probably already tested that in case it was possible).
Possibly but unlikely a completely different program like BI appllications QlikView or Qlik Sense could read only the data and don't bother about crashed conditional formatting or similar. Qlik is just one possibility. microsoft Power BI is probably too close to Excel but may be worth trying. Also other BI programs that have the possibility to load directly from Excel files.
I have been in the same situation soo many times and started to use F12 (Save as) to add a timestamp to the file like every ten minutes.
Some times I also add a note on what I am working on at the moment, or what I am about to start to do so I have a version to go back to in case I would like to.
MyWork_231122_1248.xlsx
MyWork_231122_1252 to be newSumByCol.xlsx
MyWork_231122_1259.xlsx
MyWork_231122_1317 golden master.xlsx
MyWork_231122_1333 delivered.xlsx
Using a notation like YYMMDD the files will be sortable also by names.
Thanks a lot. I will use the last version from July. Have a blessed week.
