• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

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
0
jegajothy
Asked:
jegajothy
  • 6
  • 5
1 Solution
 
Tommy8252Commented:
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.
0
 
jegajothyretiredAuthor Commented:
It shows 17, but nothing is displayed.  Funny, though it also happened to my 2007 Word software too.  All the recent documents are gone.
0
 
ckivmlCommented:

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!
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
jegajothyretiredAuthor Commented:
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.
0
 
ckivmlCommented:
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
0
 
ckivmlCommented:
you will find the explorer here HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer

expand policies then you can see explorer
0
 
jegajothyretiredAuthor Commented:
in response to ckivml, The directory "policies" does not expand.  See attached. thank u.
policies.docx
0
 
ckivmlCommented:
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
0
 
ckivmlCommented:
After this restart your Lap or apply following command in Command prompt or in Run

gpupdate /force

then open your Ms word and check it out..
0
 
jegajothyretiredAuthor Commented:
in response to ckivml, thank u it worked.   When I observe such solutions, I consider them as a work of Art. thank u.
0
 
jegajothyretiredAuthor Commented:
Fantastic, it worked. thank u
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now