Default File Location change

P

Polyprod

One of our managers has tried to change the default file location under
[Tools]-[options] . Unfortunately he typed in a / instead of a \ . Now I
cannot change anything under [Tools]-[options] I just get the message "Cannot
open location "T:/files".

Is there a file I can edit with something like notepad to just change the
setting "Default File Location" on th eGeneral tab of [Tools]-[options].

I am using Windows XP Pro (sp2) and Excel XP.

Any help appreciated.

Kevan
 
D

DMan

Kevan,

If you're a sys admin .. login in as the manager and provoded you're au fait
with changing registry settings, there's a setting under HKEY_CURRENT_USER
In the registry under Software\Microsoft\Office\10.0\Excel\Options... it's a
string value called Default Path ... editing this to the correct path should
fix the problem. I've only got Excel 2003 to test against (Office 11) so I'm
assuming the registry construct is the same for Excel XP/2002, but this
should work.

Regards,
DMan
 
D

DMan

Kevan,

If you're a sys admin .. login in as the manager and provoded you're au fait
with changing registry settings, there's a setting under HKEY_CURRENT_USER
In the registry under Software\Microsoft\Office\10.0\Excel\Options... it's a
string value called Default Path ... editing this to the correct path should
fix the problem. I've only got Excel 2003 to test against (Office 11) so I'm
assuming the registry construct is the same for Excel XP/2002, but this
should work.

Regards,
DMan
 
D

DMan

Kevan,

If you're a sys admin .. login in as the manager and provoded you're au fait
with changing registry settings, there's a setting under HKEY_CURRENT_USER
In the registry under Software\Microsoft\Office\10.0\Excel\Options... it's a
string value called Default Path ... editing this to the correct path should
fix the problem. I've only got Excel 2003 to test against (Office 11) so I'm
assuming the registry construct is the same for Excel XP/2002, but this
should work.

Regards,
DMan
 
D

DMan

Kevan,

If you're a sys admin .. login in as the manager and provoded you're au fait
with changing registry settings, there's a setting under HKEY_CURRENT_USER
In the registry under Software\Microsoft\Office\10.0\Excel\Options... it's a
string value called Default Path ... editing this to the correct path should
fix the problem. I've only got Excel 2003 to test against (Office 11) so I'm
assuming the registry construct is the same for Excel XP/2002, but this
should work.

Regards,
DMan
 
D

DMan

Kevan,

If you're a sys admin .. login in as the manager and provoded you're au fait
with changing registry settings, there's a setting under HKEY_CURRENT_USER
In the registry under Software\Microsoft\Office\10.0\Excel\Options... it's a
string value called Default Path ... editing this to the correct path should
fix the problem. I've only got Excel 2003 to test against (Office 11) so I'm
assuming the registry construct is the same for Excel XP/2002, but this
should work.

Regards,
DMan
 
D

DMan

Kevan,

If you're a sys admin .. login in as the manager and provoded you're au fait
with changing registry settings, there's a setting under HKEY_CURRENT_USER
In the registry under Software\Microsoft\Office\10.0\Excel\Options... it's a
string value called Default Path ... editing this to the correct path should
fix the problem. I've only got Excel 2003 to test against (Office 11) so I'm
assuming the registry construct is the same for Excel XP/2002, but this
should work.

Regards,
DMan
 
D

DMan

Kevan,

If you're a sys admin .. login in as the manager and provoded you're au fait
with changing registry settings, there's a setting under HKEY_CURRENT_USER
In the registry under Software\Microsoft\Office\10.0\Excel\Options... it's a
string value called Default Path ... editing this to the correct path should
fix the problem. I've only got Excel 2003 to test against (Office 11) so I'm
assuming the registry construct is the same for Excel XP/2002, but this
should work.

Regards,
DMan
 
D

DMan

Kevan,

If you're a sys admin .. login in as the manager and provoded you're au fait
with changing registry settings, there's a setting under HKEY_CURRENT_USER
In the registry under Software\Microsoft\Office\10.0\Excel\Options... it's a
string value called Default Path ... editing this to the correct path should
fix the problem. I've only got Excel 2003 to test against (Office 11) so I'm
assuming the registry construct is the same for Excel XP/2002, but this
should work.

Regards,
DMan
 
P

Polyprod

Much obliged.

It worked a treat. Why I didn't try that I just dont know.

Thanks a million for your trouble DMan !
 
P

Polyprod

Much obliged.

It worked a treat. Why I didn't try that I just dont know.

Thanks a million for your trouble DMan !
 
P

Polyprod

Much obliged.

It worked a treat. Why I didn't try that I just dont know.

Thanks a million for your trouble DMan !
 
P

Polyprod

Much obliged.

It worked a treat. Why I didn't try that I just dont know.

Thanks a million for your trouble DMan !
 
P

Polyprod

Much obliged.

It worked a treat. Why I didn't try that I just dont know.

Thanks a million for your trouble DMan !
 
P

Polyprod

Much obliged.

It worked a treat. Why I didn't try that I just dont know.

Thanks a million for your trouble DMan !
 
P

Polyprod

Much obliged.

It worked a treat. Why I didn't try that I just dont know.

Thanks a million for your trouble DMan !
 
P

Polyprod

Much obliged.

It worked a treat. Why I didn't try that I just dont know.

Thanks a million for your trouble DMan !
 

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

Access Lock File .LACCDB / Now shows as a notepad file 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Set file location defaults 6
Macro Code for bringing up Save As dialog box and changing file Type 0
Outlook 2016: recent change to add account. No browse for data file. 0
default file location 4
Default File Location-Excel 2003 3

Top