by Don » Thu Dec 08, 2011 10:33 am
You can check if there is an autorecover or saved file in the application data. You will want to go somewhere like this:
C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\
Or, to find the exact location on your computer, go to Excel > Office Button > Excel Options > Save > and look in the Save Workbooks section.
That said, there is no guarantee that this would work since the file was saved yesterday. A good approach in the future might be to store a tracking file in another folder. You could setup a macro that would automatically save a backup version to another folder each time you went to close this file.