Forum Discussion
Bradclash
Mar 03, 2022Copper Contributor
Excel crashing and and losing hours/days of work
Hi All, I have a user who regularly uses MS Excel Home & Business 2016/2021 sheets that have months/days of data. Sometimes when they work on these Excel files, it crashes and it loses hours/...
bosinander
Mar 04, 2022Iron Contributor
In my experience, Excel crashes a lot less now than in earlier versions. My routine is to not rely on autosave, nor repaired files. I turn autosave off and decide by myself when to save, and I do it by pressing F12 (save as) and append a time stamp on the file name like "Routines_220305_075.xlsx" using YYMMDD_hhm to have them the sortable by name in chronogical order.
I omit the second minute figure and thus have a new name every tenth minute.
Also happens that I append a note about the files development eg
Routines_220305_080 table of contents sheet.xlsm
The purpose is that if I want to go back to a previous version and chose another development path, I can easier chose what file to continue from.
When testing different solutions, I always do it in the original file - not a test file since it will become the origin if the test works out fine and I do not want two original named files.
Finally, I put all the passed files in a folder named like "2bdeleted in May 2022".
The main issue, having Excel not to crash?
Sorry, I do not have the solution, but F12 (and Ctrl+12 to open in fewer steps) has been very useful to both me and my customers also in other applications when the software acts like crash generators.
I omit the second minute figure and thus have a new name every tenth minute.
Also happens that I append a note about the files development eg
Routines_220305_080 table of contents sheet.xlsm
The purpose is that if I want to go back to a previous version and chose another development path, I can easier chose what file to continue from.
When testing different solutions, I always do it in the original file - not a test file since it will become the origin if the test works out fine and I do not want two original named files.
Finally, I put all the passed files in a folder named like "2bdeleted in May 2022".
The main issue, having Excel not to crash?
Sorry, I do not have the solution, but F12 (and Ctrl+12 to open in fewer steps) has been very useful to both me and my customers also in other applications when the software acts like crash generators.
Bradclash
Mar 06, 2022Copper Contributor
Thank you for your reply, it sounds like a fine system you've set up but I don't think my user will be satisfied with doing that. Hoping if there's a more concrete solution to this issue.