Can't enter any data, please help.

Originally Posted by namelessgrl

I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar. I am extremely confused, can anyone help?

Hi,

try Windows 'Start', Control Panel, Accessibility Options, and clear any ticked box in Keyboard, Mouse, Display or Sound, and in General tick only the two Notifications.

Then start Excel.

If the problem persists, then try, Close Excel and

Windows 'Start' Button, select 'Run', and type
excel /unregserver
then
Windows 'Start' Button, select 'Run', and type
excel /regserver

Search for a file *.xlb and remove it

Search for a file Personal.xls and rename (to hide) it.

Let me know how you go.
---

Originally Posted by namelessgrl

Do I just go under the 'Start' and then 'Search' to look for the *.xlb file? Cause I tried that and didn't come up with any thing.

to Search, rightmouse the Start button and select search, as is a normal Windows Search.

---.

Originally Posted by namelessgrl

I don't know if this will help in solving the problem, but when I click on a different spreadsheet within the same file my cursor becomes an arrow with a piece of paper and I can't click on anything?

if you click and hold a tab this happens, make sure that your mouse button is releasing,

---

Originally Posted by namelessgrl

The search didn't come up with anything and my mouse seems to be working properly. Any other suggestions?

yes, redo the search to a successful conclusion and try a different mouse.

If you click on a worksheet tab and have a small down-arrow indicating position together with a sheet with an arrow then you are in the position of 'click-and-hold' that tab, you can move the sheet to left or right to re-position the sheet.

The pc believes that you are holding the mouse button, either by some sticky-key function, bad mouse, or bad mouse driver.

What was ticked in the 'sticky-keys' (the Accessibility) section?

--------

go to

C:\Documents and Settings\HomeUser\Application Data\Microsoft\Excel

but replace 'HomeUser' with the login name that you use.

In there is a .xlb file

delete that file.

-------

Let me know how you go.
---