Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
pentotis
 
Posts: n/a
Default Excel "recently used files" setting is greyed out. How to use it?

I should like to have two or three files available from the File Menu
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default Excel "recently used files" setting is greyed out. How to use it?

Goto Tools/Options......under the General tab select "Recently used file
list" and ajust to suit your need.....up to 9 entries.

HTH
JG

"pentotis" wrote:

I should like to have two or three files available from the File Menu

  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Excel "recently used files" setting is greyed out. How to use it?

And maybe...

OFFXP: "Most Recently Used" List Missing from File Menu and "Recently Used
File List" Option Unavailable (Q284896)
http://support.microsoft.com/default...;EN-US;q284896

Any chance you just turned on TweakUI?



pentotis wrote:

I should like to have two or three files available from the File Menu


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rusty35
 
Posts: n/a
Default Excel "recently used files" setting is greyed out. How to use

I have the same problem with all my Office programs - and I do not use TWEAK.
I have run the otherrecommended options (normal.dot, registry fix etc)
without success.

List Recent Documents is ticked on Start Menu options as well - but nothing
is happening there either!

Any suggestions?

--
Rusty


"Dave Peterson" wrote:

And maybe...

OFFXP: "Most Recently Used" List Missing from File Menu and "Recently Used
File List" Option Unavailable (Q284896)
http://support.microsoft.com/default...;EN-US;q284896

Any chance you just turned on TweakUI?



pentotis wrote:

I should like to have two or three files available from the File Menu


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Excel "recently used files" setting is greyed out. How to use

I don't have a guess on why you can't change this, but if you feel comfortable
changing the registry, you can try this:

I use xl2003, so this version number could change for you (it's 11 in xl2003).

Close excel
windows start button|run|Regedit

Backup the registry before you start (and be careful).

HKCU/Software/Microsoft/Office/11.0/Excel\Options
change: Option5 to 885
and
change: DefFileMRU to 9





Rusty35 wrote:

I have the same problem with all my Office programs - and I do not use TWEAK.
I have run the otherrecommended options (normal.dot, registry fix etc)
without success.

List Recent Documents is ticked on Start Menu options as well - but nothing
is happening there either!

Any suggestions?

--
Rusty

"Dave Peterson" wrote:

And maybe...

OFFXP: "Most Recently Used" List Missing from File Menu and "Recently Used
File List" Option Unavailable (Q284896)
http://support.microsoft.com/default...;EN-US;q284896

Any chance you just turned on TweakUI?



pentotis wrote:

I should like to have two or three files available from the File Menu


--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
bretsharon
 
Posts: n/a
Default Excel "recently used files" setting is greyed out. How to use

Dear Dave, I have tried the registry fix you mention, but this doesn't
work. Off topic, doesn't restore system work for the registry change? I'd
much rather use that, than getting into the registry. Now, the long version
of the fix.

Try instead: --------------- How do I restore the Recent Documents
function? (Office XP/Office 2003) When you click the File menu in Word and
other Office XP or Office 2003 applications, you should see a list of
documents you accessed recently. If you don't see a list, it could be because
you instructed Word to not display any recent documents, but if you did
enable the function and the documents don't appear, you might be encountering
a bug.

In one of your Office programs, open the Tools menu, click Options, and
choose the General tab. If the Recently Used File List option isn't selected,
try selecting it. If you can't select it, you need to delete a Registry value
to get it back. (Don't forget to back up your system before you tweak the
Registry.)

Close Word, open Registry Editor (refer to the previous tip for these
steps), and navigate to the following key:
HKEY_CURRENT_USER\SOFTWARE\MICROSOFT
\WINDOWS\CURRENTVERSION\POLICIES\EXPLORER. In the right pane, right-click
the NoRecentDocsHistory value, click Delete, and click Yes to confirm the
deletion. Restart Word and return to the General tab in the Options dialog
box. You should now be able to select the Recently Used File List option, as
well as the number of recent documents you'd like to see each time you click
the File menu.



"Dave Peterson" wrote:

I don't have a guess on why you can't change this, but if you feel comfortable
changing the registry, you can try this:

I use xl2003, so this version number could change for you (it's 11 in xl2003).

Close excel
windows start button|run|Regedit

Backup the registry before you start (and be careful).

HKCU/Software/Microsoft/Office/11.0/Excel\Options
change: Option5 to 885
and
change: DefFileMRU to 9





Rusty35 wrote:

I have the same problem with all my Office programs - and I do not use TWEAK.
I have run the otherrecommended options (normal.dot, registry fix etc)
without success.

List Recent Documents is ticked on Start Menu options as well - but nothing
is happening there either!

Any suggestions?

--
Rusty

"Dave Peterson" wrote:

And maybe...

OFFXP: "Most Recently Used" List Missing from File Menu and "Recently Used
File List" Option Unavailable (Q284896)
http://support.microsoft.com/default...;EN-US;q284896

Any chance you just turned on TweakUI?



pentotis wrote:

I should like to have two or three files available from the File Menu

--

Dave Peterson


--

Dave Peterson

  #7   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Excel "recently used files" setting is greyed out. How to use

I would think that system restore would restore whatever settings were there
when the last "picture of the system" was taken. So maybe it'll work, maybe
not.

It sounds like you got it fixed. Looking at that fix, is there any chance that
you used TweakUI. I don't use it nowadays, but I seem to recall a tab that had
some kind of "paranoia" settings. (I _think_ it was TweakUI--but it could have
been a different utility.)

Is there a chance you used that and turned off the MRU?

I just loaded TweakUI for winXP.

Unert the Explorer category (main category--not any subcategory), there's an
option to "maintain document history". The description says that this controls
the Documents list (under the Windows Start button) and the MRU under many
applications.

Paranoia settings must have come from a different utility (or an earlier version
of TweakUI).

bretsharon wrote:

Dear Dave, I have tried the registry fix you mention, but this doesn't
work. Off topic, doesn't restore system work for the registry change? I'd
much rather use that, than getting into the registry. Now, the long version
of the fix.

Try instead: --------------- How do I restore the Recent Documents
function? (Office XP/Office 2003) When you click the File menu in Word and
other Office XP or Office 2003 applications, you should see a list of
documents you accessed recently. If you don't see a list, it could be because
you instructed Word to not display any recent documents, but if you did
enable the function and the documents don't appear, you might be encountering
a bug.

In one of your Office programs, open the Tools menu, click Options, and
choose the General tab. If the Recently Used File List option isn't selected,
try selecting it. If you can't select it, you need to delete a Registry value
to get it back. (Don't forget to back up your system before you tweak the
Registry.)

Close Word, open Registry Editor (refer to the previous tip for these
steps), and navigate to the following key:
HKEY_CURRENT_USER\SOFTWARE\MICROSOFT
\WINDOWS\CURRENTVERSION\POLICIES\EXPLORER. In the right pane, right-click
the NoRecentDocsHistory value, click Delete, and click Yes to confirm the
deletion. Restart Word and return to the General tab in the Options dialog
box. You should now be able to select the Recently Used File List option, as
well as the number of recent documents you'd like to see each time you click
the File menu.



"Dave Peterson" wrote:

I don't have a guess on why you can't change this, but if you feel comfortable
changing the registry, you can try this:

I use xl2003, so this version number could change for you (it's 11 in xl2003).

Close excel
windows start button|run|Regedit

Backup the registry before you start (and be careful).

HKCU/Software/Microsoft/Office/11.0/Excel\Options
change: Option5 to 885
and
change: DefFileMRU to 9





Rusty35 wrote:

I have the same problem with all my Office programs - and I do not use TWEAK.
I have run the otherrecommended options (normal.dot, registry fix etc)
without success.

List Recent Documents is ticked on Start Menu options as well - but nothing
is happening there either!

Any suggestions?

--
Rusty

"Dave Peterson" wrote:

And maybe...

OFFXP: "Most Recently Used" List Missing from File Menu and "Recently Used
File List" Option Unavailable (Q284896)
http://support.microsoft.com/default...;EN-US;q284896

Any chance you just turned on TweakUI?



pentotis wrote:

I should like to have two or three files available from the File Menu

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
Setting Tab in Excel RabbiWife Excel Discussion (Misc queries) 5 April 26th 07 09:44 AM
Excel Sheet default setting. vishu Excel Discussion (Misc queries) 2 September 29th 05 04:36 PM
Need help setting up a >< IF formula in Excel, Sheryl Excel Worksheet Functions 2 May 18th 05 07:22 PM
Need help setting up a >< IF formula in Excel, Gary Brown Excel Worksheet Functions 0 May 18th 05 05:41 PM


All times are GMT +1. The time now is 11:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"