Help

  • Thread starter Thread starter KHORN
  • Start date Start date
K

KHORN

I recently purchased Microsoft Office XP and am having trouble wit
Excel. I have created a spreadsheet and now want to add information
unfortunetly, the program will not allow me to do so. None of my tool
work they are gray so I am unable to use anything in the tool bar. Thi
is happening with every spreadsheet. It is not allowing me to edit.
can create new but once the information is in the cell I cant chang
it, the curser doesnt even blink. I tried reinstalling and updating an
patches... Any other suggestions?
THanks for any/all help
 
K,

One possibility is that your worksheet is protected. Try Tools -
Protection. If you have a "Protect sheet," do nothing, it's not protected.
If you have "Unprotect sheet," use it.

Can you create a new workbook? Do the tools work then?
 
One possibility is that your worksheet is protected. Try Tools -
Protection. If you have a "Protect sheet," do nothing, it's no
protected.
If you have "Unprotect sheet," use it.

Can you create a new workbook? Do the tools work then?

**** Thanks for responding Earl. Checked the "Tools" "Protection" on i
and cant use it. The tools are gray and not allowing me to adjus
anything. I also tried to create a new spreadsheet and my tools ar
still not accessable. Any other suggestions??? Thanks again
 
This happens when you do File|New, too?

If yes, then I'd start excel in Safe mode to see what happens.

Close excel
Windows start button|Run
excel /safe

File|open the workbook and see what happens.

If it all my icons worked on a brand new workbook, the next thing I'd try is to
close excel and rename my file that holds the customized toolbars.

Close excel
Windows start button|Find/Search
look for *.xlb (look in hidden folders and for hidden files)
Rename them all to *.xlbOLD

Then back to excel (this time just normal excel) to see if that worked.

If it did, recreate your toolbar customizations from scratch and delete those
*.xlbOLD files.

If it didn't rename them back and keep looking.

If you didn't help, then use that link to Chip Pearson's site that Earl gave
you.
http://www.cpearson.com/excel/StartupErrors.htm

Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)

Then one by one, you'll add one back and restart excel to see if that caused the
problem.
 
Back
Top