i need helps with Options on the tools menu

A

Alfie

When i go into options on the tools menu and click on the tabs it states that
it cannot access the directory (and the directory name). How do i change
this?
 
G

Gord Dibben

This is usually caused by exceeding the 255 character limit in the path to your
Alternate Startup folder or your default file location in Tools>Options>General

You will probably have to go into Registry and delete the key(s)

First close out Excel then create a new Windows Restore Point.

Then Start regedit>run

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

In right side window click on AltStartup and "delete"

Also check out DefaultPath and delete that if looks too long.

Don't worry, Excel will re-build the keys with new path you give in
Tools>Options>General

Close Registry.

Try Tools>Options again.

If all is joy, re-enter Default File location but make sure it is a shorter
path.

Leave the other empty........serves very little purpose.


Gord Dibben MS Excel MVP
 

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

Similar Threads

clicking TOOLS/OPTIONS gives me error msg "cannot access dir D:/" 1
Cannot get into the 'options' menu, any suggestions? 2
Options access 1
Hidden tabs on my worksheet 3
Template file location 8
In Tools <Options -any selection I make returns a !Warning "Can't 3
How can I make the status bar to be displayed as default? 2
Can't change options 4

Top