[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel 2007

Posted on 2011-05-08
12
Medium Priority
?
298 Views
Last Modified: 2012-05-11
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
Comment
Question by:jegajothy
  • 6
  • 5
12 Comments
 

Expert Comment

by:Tommy8252
ID: 35715535
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
 

Author Comment

by:jegajothy
ID: 35715606
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
 
LVL 6

Expert Comment

by:ckivml
ID: 35715968

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:jegajothy
ID: 35716069
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
 
LVL 6

Expert Comment

by:ckivml
ID: 35717724
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
 
LVL 6

Expert Comment

by:ckivml
ID: 35717727
you will find the explorer here HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer

expand policies then you can see explorer
0
 

Author Comment

by:jegajothy
ID: 35719982
in response to ckivml, The directory "policies" does not expand.  See attached. thank u.
policies.docx
0
 
LVL 6

Expert Comment

by:ckivml
ID: 35720262
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
 
LVL 6

Accepted Solution

by:
ckivml earned 2000 total points
ID: 35720273
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
 

Author Comment

by:jegajothy
ID: 35720825
in response to ckivml, thank u it worked.   When I observe such solutions, I consider them as a work of Art. thank u.
0
 

Author Closing Comment

by:jegajothy
ID: 35720827
Fantastic, it worked. thank u
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question