Link to home
Start Free TrialLog in
Avatar of Jegajothy vythilingam
Jegajothy vythilingamFlag for United States of America

asked on

Excel 2007

My OS is windows 7.  Not sure what happened or what I did, but now my recent documents do not show up whenever I open Excel and click on the logo.  From windows 7, it does not show up too - maybe I had been using too many documents lately.  How do I adjust so that it could show up the max recent documents possible. thank u
Avatar of Tommy8252
Tommy8252

1.Click the Microsoft Office Button, and then click Excel Options.
2.Click Advanced.
3.Under Display, in the Show this number of Recent Documents list, click the number of files that you want to display.
Avatar of Jegajothy vythilingam

ASKER

It shows 17, but nothing is displayed.  Funny, though it also happened to my 2007 Word software too.  All the recent documents are gone.

The following registry key worked for me

HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer

A DWord Value named NoRecentDocsHistory, with a value of 0 should restore your Recent Documents for MS Office.

A value of 1 will disable the Recent Documents "feature."

If you're part of a domain, however, it is possible that your administrator may be controlling this registry entry by Group Policy, and you won't be able to change it. In that case, you'll have to contact your system admin.

See the following MS TechNet page for more information:
http://www.microsoft.com/technet/pro....mspx?mfr=true

Hope this helps!
in response to ckivml, in your first response, I managed to go down to as far as Policies, but there is nothing in that i.e. I do not see Explorer.  So I am stuck.
To your 2nd suggestion, I could not locate the following the steps in the InfoPath.  Where is the Tools menu located, I do not see it in Options.  :
Excel
1.Click the Microsoft Office Button, and then click Excel Options.
2.Click Advanced.
3.Under Display, in the Show this number of Recent Documents list, click the number of files that you want to display.
 Top of Page

InfoPath
1.On the Tools menu, click Options, and then click the General tab.
2.Select or clear the Recently used file list check box.
3.If you want to show your recently used files, in the Entries list, click the number of files that you want to display.

My apologies in being so basic. thank u.
Go to Run :

type >>   regedit

go to

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer

select Explorer then Right Click New >> A DWord Value named "NoRecentDocsHistory" without Quote

now you can see NoRecentDocsHistory in right panel double click on it.. change the value data as 0

then go to Run type gpupdate /force enter it will apply all the policy changes do this twice then check your word you will see recent documents..

kindly revert if you need any more information
you will find the explorer here HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer

expand policies then you can see explorer
in response to ckivml, The directory "policies" does not expand.  See attached. thank u.
policies.docx
Please find the attachment for Explorer Key

Download this ZIP file then Extract it.. double click on explorer.reg click yes if it ask for some permission...
Explorer.zip
ASKER CERTIFIED SOLUTION
Avatar of ckivml
ckivml
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
in response to ckivml, thank u it worked.   When I observe such solutions, I consider them as a work of Art. thank u.
Fantastic, it worked. thank u