lost the X function in Excel

M

Michael

Help! I have office XP, and I have been using excel for
a little while. All of a sudden, the red X in the upper
right corner is grayed out. Also, on the file menu, Save
and Save as are no longer available. I tried adding them
back in, but I can't find them. Is this a macro problem
or something? This happened to me on another computer,
and I can't figure it out.
Thanks for any help you can give me,
Mike
 
R

Ron de Bruin

Hi Michael

Try this

Try to rename your .xlb file

maybe you have a corrupt or bloated xlb file
*normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

Close Excel
Do a search for .xlb in windows
Rename the file you find (mine is named Excel10.xlb in 2002)
Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
This file is important (backup it so you can restore it)
 
Top