Perhaps you are saving to the different place and then saving from THERE and
re-opening from the original place. Here is something I have used:
Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub
--
Don Guillett
SalesAid Software

"Theslaz" wrote in message
news:CGE0i.25308$au6.18711@edtnps90...
Just started to have a problem with Excel not saving my work. I have a
worksheet set up to do my invoicing. When I'm done inputing my new
information and before I close; I; of course will want to save. If I press
the "Save" icon in the tool bar, Excel will show that it is saving the
worksheet in the lower tool bar. It will say "saving Master Invoice" and
then ready. If I close and re-open the worksheet; I will find that nothing
was saved. I have tried using the menu item "File" and then "Save as" and
I get the same results. My only saving grace is that I have two Macros set
up in my work sheet; one is a button to save the worksheet on second
different drive and the other is a second button to save my worksheet on a
external USB drive. These work and this is what I have been using to get
by.

It can be noted that I had a system crash and had to re-install windows Xp
professional from a backup I had. I have various problems with the system
as we speak and I have been tweaking the system as they pop up. This
problem ha me baffled.