Excel 2003

R

Ryan Conlon

I have a user who has the File > Open (native) and File > Save (native)
options in Excel 2003.

When the users selects File > Open there are no My Places option on the file
explorer that opens up (although it is there for the native option).

I have run a clean install and checked in the users profiles and it seems
there are no start up files assosicated.

How do I disable this to its former state of just File > Open (with my
places option) and File > Save.

Thanks for your time.

Ryan
 
B

Beth Melton

Ryan Conlon said:
I have a user who has the File > Open (native) and File > Save (native)
options in Excel 2003.

When the users selects File > Open there are no My Places option on the
file
explorer that opens up (although it is there for the native option).

I have run a clean install and checked in the users profiles and it seems
there are no start up files assosicated.

How do I disable this to its former state of just File > Open (with my
places option) and File > Save.

Have you tried starting Excel in Safe Mode to see if the issue occurs? Start
Excel while holding Ctrl. Continue holding Ctrl until prompted to start in
Safe Mode.

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx
 
H

Harlan Grove

Ryan Conlon said:
I have a user who has the File > Open (native) and File > Save (native)
options in Excel 2003.

When the users selects File > Open there are no My Places option on the file
explorer that opens up (although it is there for the native option).
....

First thins to check would be the user's .XLB file is to blame. That's
where Excel stores menu customizations. You should find it under
%APPDATA%\Microsoft\Excel\Excel11.xlb. Append an extra extension
like .save, then run Excel. Excel will create a new factory
default .XLB file. Does that fix the problem?

If not, Office reinstalls wouldn't necessarily fix this if you don't
also clean out the user's registry between uninstalling Office and
reinstalling it. Try the following.

1. Save the following registry keys (with all subkeys)

HKCU\Software\Microsoft\Office

and

HKLM\Software\Microsoft\Office

to .REG files for selective merging later.

2. FULLY UNINSTALL Office.

3. Fully delete the two registry keys above from the registry (you
have the .REG files as backup for settings that aren't causing this
problem).

4. Reinstall Office.

5. Check whether this problem persists. If it does, then this
particular machine may have an aberrant DLL. If that's the case, a
complete C: drive reformat/software reinstall may be in order. Don't
forget to backup user document files before formatting and restoring
them after software reinstall.

6. OTOH, if this fixes the problem, save the two registry keys above
as different files, then compare them to the ones you saved before the
uninstall. It should be possible to isolate the offending settings
that caused this problem. If so, delete those settings from the first
set of .REG files, then merge those .REG files back into the registry
(thus restore the user's settings which are unrelated to this
problem).

Finally, better to ask Excel-specific questions in Excel-specific
newsgroups.
 
Top