Right Click menu missing for cells

[Barry A&P]

I am trying to fix a friends excel 2003 spreadsheet and when i right click a
cell only a small blank menu shows up.. the Tools menu was also blank but i
was able to use the options tab to restore it, However i can not find a
place to restore the right click menu.. any help would be appreciated..

thanks
Barry

 

[Ron de Bruin]

You must do this with code or rename your xlb file
I think this is the best option for you

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

1) Close Excel
2) Do a search for .xlb in Windows (Use: search hidden files and folders)
3) Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4) Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file 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)