I was told if changes are save on current excel worksheet that you can recover the original worksheet or that it no longer exist on the hard drive is this true?

I need to find old worksheets. I created a worksheet to keep track of proceeds and updated it almost daily for 9 months. Is it possible for all of these worksheet to still exist on the hard drive?

Sorry with my pea brain I don't even know if this is a dumb question.

Thanks in advance,

popupgotme

To the best of my knowledge, unless you saved each worksheet separately before making changes to it and then saved THAT worksheet, then you have overwritten the same file with new data. There would be no different files to retrieve practically.
Regards,
John

Hi,
Whoever told to that, doesn't know what they are talking about

You still have the original but now it's changed,
Here is one way to back up a file,
http://72.14.253.104/search?q=cache:zQsqFW...lient=firefox-a

Here is a way with VBA
You can place it in before close and/or before save workbook events,
[code][/code]Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim Msg As String
Dim ans As Integer
Dim fname As String
Dim MyDate
Dim MyMonth
MyDate = Date
MyMonth = Month(MyDate)
Msg = "Would you like to back up file?"
ans = MsgBox(Msg, vbYesNo)
If ans = vbYes Then
ThisWorkbook.SaveAs Filename:="C:\Backup\" & MonthName(MyMonth) & "-" & Day(Date) & "-" & Year(Date) & "-" & ThisWorkbook.Name
End If

End Sub
When you close the workbook, it asks if you want to back up the file, choose yes and it will save in a backup folder the workbook name and the date saved, the backup folder must exist for this code to work