data menu lost

[exile]

Hi all

The menu bar has changed from the standard menu functions to what
appears to be chart funtions. I have file, edit, view, insert, format,
tools, chart, window, help. I have lost the Data menu function and
most of the functions under Insert and format.
I have tried to reset the toolbar as well as uninstalling and
reinstalling Excel with no luck.


Thanks for advise

 

[Dave Peterson]

Do you have a chart on that worksheet? And if yes, is that chart selected?

(try clicking on a worksheet cell to get off the chart.)

 

[exile]

No I haven't anyting no data no chart, it is new workbook as Book1 and
problem has continue on all my excel files.

 

[Dave Peterson]

One way to reset all of excel's toolbars is:

close excel
windows start button|search
look for *.xlb (in hidden folders, too)

Rename all you find to *.xlbOLD

Restart excel and see if that fixed it.

If it did, then just delete the *.xlbOLD files.

Since this deletes the file that holds all your customized toolbars, you'll have
to make those modifications (if you modified anything).

 

[exile]

Thanks for suggestion Dave.
The problem is ,there isn't any *.xlb files on my windows.
Is this strange?

 

[Dave Peterson]

I bet you have one, but you're just having trouble finding it.

Start excel and tools|customize
and create a new toolbar (custom 1 or whatever the default name will be fine)

Now close excel and look again.

If you don't find it, then my bet is windows is hiding it too well.

Make sure you look through hidden folders.

Maybe looking again using an old DOS command would help:

(Windows start button|run
for winNT/win2k (winXP): cmd
for win9*, type: command

Then

dir c:\*.xlb /s /ah

(change that C: to the drive that holds excel.exe.)


If you find more than one *.xlb file, you'll know the "real" one is the one you
just modified.

 

[exile]

Thank you so much David.You are great.