There are a couple of ways you might be able to recover unsaved Excel work after encountering errors:

1. AutoRecover: Excel has a built-in feature called AutoRecover that automatically saves a temporary copy of your work at regular intervals. If your program crashes or closes unexpectedly, you might be able to retrieve this unsaved version.

Here's how to check for AutoRecover files:

- Open a new Excel workbook.
- Click on "File" in the top left corner.
- Go to "Info" or "Options" depending on your Excel version.
- Look for a section titled "AutoRecover" or "Manage Workbooks".
- There you should see an option to "Recover Unsaved Workbooks".

- If you find an unsaved workbook related to your lost work, you can open it and hopefully recover most of your recent changes.

2. Temporary Files: In some cases, temporary files might be created during your work session. These are less likely to hold your complete work, but they might contain fragments of your unsaved data.

- The location of temporary files can vary depending on your operating system and Excel version. You can try searching for ".tmp" files in your temporary folder. (Note: Recovering data from temporary files is a complex process and may not be successful.)

Prevention is Key:

To minimize the risk of losing unsaved work, it's highly recommended to:

- Save frequently: Get into the habit of saving your work regularly using the "Save" button (Ctrl+S) or enabling AutoSave at shorter intervals.
- Enable AutoRecover: Ensure AutoRecover is turned on in your Excel settings. This will automatically create backups at set intervals.

By following these practices, you'll be better prepared to recover from unexpected errors and avoid losing your valuable work.