worksheet menu bar

M

Mike Molyneaux

Running 2003, xp pro sp 2.

User cannot access the Options item on the Tools submenu in the Worksheet
Menu Bar.

At least one spreadsheet is open.

Options is not greyed out.

When anyone else logs onto her machine, it works perfectly.

I logged on as Administrator and ran Repair via add/change programs - didn't
help her.

The registry contains the following in

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Toolbars\Settings

Value 7
Name: Microsoft Excel AWDropdownHidden
Type: REG_DWORD
Data: 0x1

Anyone know what this is?

Should I remove it?

She swears she has not deleted or changed
anything and that it worked fine yesterday.

Any ideas about what may have happened?



Thanks - Mike
 
J

Jim Rech

This problem has been known to occur when an Excel setting becomes
corrupted. With Excel closed go to this key in Regedit:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

and rename Options to say OptionsX. When you restart Excel it should be
okay although you may lose a few preferences that should be easy to reset.

--
Jim
| Running 2003, xp pro sp 2.
|
| User cannot access the Options item on the Tools submenu in the Worksheet
| Menu Bar.
|
| At least one spreadsheet is open.
|
| Options is not greyed out.
|
| When anyone else logs onto her machine, it works perfectly.
|
| I logged on as Administrator and ran Repair via add/change programs -
didn't
| help her.
|
| The registry contains the following in
|
| HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Toolbars\Settings
|
| Value 7
| Name: Microsoft Excel AWDropdownHidden
| Type: REG_DWORD
| Data: 0x1
|
| Anyone know what this is?
|
| Should I remove it?
|
| She swears she has not deleted or changed
| anything and that it worked fine yesterday.
|
| Any ideas about what may have happened?
|
|
|
| Thanks - Mike
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top