Hi @susie,
I'm not sure the reason for sudden closure of Excel based on the information you provided. I suggest you try to recover the file by following the steps in this article: Recover an earlier version of an Office file.
Let us know if there is any update or progress.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.