Excel won't save

  • Thread starter Thread starter Theslaz
  • Start date Start date
T

Theslaz

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.
 
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
 
Hi Theslaz,
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.
Click to expand...

Are you SURE you are opening the same file after this save?

What happens if you start Excel in safe mode (hold the control key when you
open Excel)?

What Excel version?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
It does "Save" if I do what you suggest and open with the Ctrl Key held
down.
The version I am using is Excel 2002

I have tried a few things. One thing I noticed after I reinstalled my
operating system is that when I open Excel; a dialog box opens and it
states that it is installing a Component. If I allow it to complete;
after about 3 or 4 seconds a progress bar completes and the box goes
away and Excel loads as it did before. This Dialog box did not show up
before. What I have been doing is "canceling" the install of the
component; however; today I let it install and tried a save. It worked.
It appears that I have to let this "Component" install!

Any takes on that and is there a work around.
 
Hi Theslaz,
One thing I noticed after I reinstalled my
operating system is that when I open Excel; a dialog box opens and it
states that it is installing a Component. If I allow it to complete;
after about 3 or 4 seconds a progress bar completes and the box goes
away and Excel loads as it did before. This Dialog box did not show up
before. What I have been doing is "canceling" the install of the
component; however; today I let it install and tried a save. It worked.
It appears that I have to let this "Component" install!
Click to expand...

This implies something is wrong with your Excel installation.
I'd advise you to run Office Setup and do a detect and repair.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Your are probably right and I did consider a reinstall. I'm just glade
that I now know what is causing it to not "Save"!

What is the purpose of using Excel in "Safe Mode"?? Just curious.
Actually didn't know that there was such a thing!

Thanks for your prompt replies and advice!

Jerry Selinger
Calgary; Alberta; Canada
 
Hi Theslaz,
What is the purpose of using Excel in "Safe Mode"?? Just curious.
Actually didn't know that there was such a thing!
Click to expand...

It is there so you can do trouble shooting. It loads Excel without all
possible customizations, so it excludes menu changes you've made and
any addins, and workbooks from your xlstart folder are not loaded.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Back
Top