Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Montreal, Quebec, Canada
    Posts
    256
    Thanks
    18
    Thanked 1 Time in 1 Post

    Excel Recent List (Excel 2007 - Win 7)

    When I click the Start Menu and hover the mouse over a program, a Right pane opens showing recently opened worksheets and those pinned to the list. Every few weeks this list of recent items disappears. Deleting Excel from the start menu and re-adding it does not fix the problem and I have to start over pinning the desired entries. Any suggestions??
    David P - The Truth Is In Redmond

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    Certainly sounds not like an Excel issue but more of a Window issue. Do you have any cleaner that are scheduled to run the cleans the recent lists, ex CCleaner?

    If you right click the start orb > Properties > Start Menu tab, make sure both items in the privacy section are ticked.

    HTH,
    Maud

    start.png

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    David,

    I reported similar behavior in another thread. It only happens to Excel on my machine not Access or Word. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Montreal, Quebec, Canada
    Posts
    256
    Thanks
    18
    Thanked 1 Time in 1 Post
    Both checked as you suggest. ONLY happens in Excel
    David P - The Truth Is In Redmond

  5. #5
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Montreal, Quebec, Canada
    Posts
    256
    Thanks
    18
    Thanked 1 Time in 1 Post
    Which thread?
    David P - The Truth Is In Redmond

  6. #6
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    This information is from Excel 14 Office 2010 Help:
    Change the number of files that appear in the list of recently used files

    1.Click the File tab.

    2.Under Help, click Options.

    3.Click Advanced.

    4.Under Display, in the Show this number of Recent Documents list, click the number of files that you want to display.

    Note These steps do not apply to InfoPath 2010.

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Berton

    ..the Excel mru (most recently used) list is not the same as the recent documents list referred to in post#1.
    (For example, you cannot 'pin' anything to the mru.)

    ..but I think it's a good idea, as you suggest, to increase the mru number to as large a number as you want!

    zeddy
    •Excel Doucument Kicker
    .

  8. #8
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,722
    Thanks
    146
    Thanked 156 Times in 149 Posts
    What's a Doucument ? And why would you want to kick it?

  9. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi

    Forgive my poor French. What I meant to put was Ducimetière.
    The kicker is part of the Large Hadron Collider injection magnet

    To briefly abstract, proton beams will be injected into LHC at 450 GeV by two kicker magnet systems, producing magnetic field pulses of approximately 900 ns rise time and up to 7.86 s flat top duration. One of the stringent design requirements of these systems is a flat top ripple of less than ± 0.5%. Both injection systems are composed of 4 travelling wave kicker magnets of 2.7 m length each, powered by pulse forming networks (PFN's). To achieve the required kick strength of 1.2 Tm, a low characteristic impedance has been chosen and ceramic plate capacitors are used to obtain 5 Omega. Conductive stripes in the aperture of the magnets limit the beam impedance and screen the ferrite.. etc etc etc

    zeddy
    •Excel French Mistranslator

  10. #10
    4 Star Lounger
    Join Date
    Jun 2011
    Location
    Hampshire (the old one)
    Posts
    525
    Thanks
    21
    Thanked 72 Times in 62 Posts
    Quote Originally Posted by Berton View Post
    This information is from Excel 14 Office 2010 Help:
    It's different (though similar) in Office 2007:

    Click Office button → Excel Options → Advanced → scroll down to the Display section.

    I get, though, that the OP is talking about the Windows MRU, not the Excel one.

  11. #11
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi

    Further to Maud's post#2, I think you need to go another step further:
    For completeness, and for the benefit of others, I'll start at the beginning:

    To show or hide Recent Items on the Win7 Start menu:
    1. Click the Win7 Start button to select the Control Panel option:
    zeddy1.gif

    2. Click the Taskbar and Start Menu option:
    zeddy2.gif

    3. Click the Start Menu tab:
    zeddy3.gif

    4. In the Privacy section, select the Store and display recently opened items in the Start menu and the taskbar check box, if not already selected.
    zeddy4a.gif

    5. Click the Customise option:
    zeddy5.gif

    6. scroll through the list of options to find the Recent Items
    zeddy6.gif

    7. Tick the checkbox, select required number of recent items to display in Jump Lists.
    8. Click OK, then click OK again

    zeddy
    •Excel Picture Snapper
    Last edited by zeddy; 2015-08-17 at 05:31.

  12. The Following User Says Thank You to zeddy For This Useful Post:

    mrjimphelps (2015-08-18)

  13. #12
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Montreal, Quebec, Canada
    Posts
    256
    Thanks
    18
    Thanked 1 Time in 1 Post
    Thanks for a very detailed refresher course on setting up Recent Items. What are your thoughts as to why the Recent list in Excel randomly comes up empty?
    David P - The Truth Is In Redmond

  14. #13
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi

    What are your thoughts as to why the Recent list in Excel randomly comes up empty?
    As Maud said in post#2, it's an issue with Windows. Specifically, with the Windows Registry.

    So to start with, make sure that, in addition to the two items mentioned by Maud in post#2, you have that checkbox ticked as in my step6 and 7 in post#11. I believe the current Win7 default is to have these unchecked.

    Fundamentally, no two PCs are alike. Ever. Even as they roll fresh off a production line, just like cars, they have different component serial numbers, build quality, software product keys, factory fitted extras etc etc. The environment that they are used in, and their Users, will always be different. They will soon have different add-ins, different usage, different logs, different updates, different customisations. Their mileage WILL differ (as RG might say).

    The main source of the problem is with how your software interacts with the Registry to keep track of all this stuff. For example, you may have a registry cleaner in use as Maud suggests. Or not.

    So lets find out what you've got. The Recent List (or Jump Lists as I prefer to call them) stores file tracking info in an AutomaticDestinations folder for all the applications you use. To see what you have, copy/type this line

    %AppData%\Microsoft\Windows\Recent\AutomaticDestin ations

    (NOTE:no spaces in AutomaticDestinations)

    ..then paste it into the Search box as shown here, and press [Enter]:
    rz-win-1.gif

    If you don't see this Search box, press [Win][R] (where [Win] is the Windows key (next to the [Alt] key) and paste, as shown here, then click [OK]:
    rz-win-2.gif

    You may then see something similar to this:
    rz-win-3.gif

    If you see any large files, say over 1MB, then delete them. This should restore the tracking functionality on restart i.e. will start tracking your 'recent' files again. If this doesn't work, then you could try the Office Repair method, with a re-boot.

    The fact that you have sporadic or intermittent loss of your Jump Lists is like having an annoying periodic rattle in your car. Hard to track down what is causing it.

    zeddy
    •Excel Cycle Therapist
    .
    Last edited by zeddy; 2015-08-18 at 09:58.

  15. The Following 2 Users Say Thank You to zeddy For This Useful Post:

    mrjimphelps (2015-08-18),RetiredGeek (2015-08-18)

  16. #14
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Zeddy,

    Went there Deleted a 2+mb file...Excel List GONE!

    Restored file Excel List BACK.

    Copied file to safe place so I can restore it next time it goes away.

    Thanks!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  17. #15
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi RG

    ..so is that a proper thanks I get then??
    ..and how do I get rid of that pesky space in
    %AppData%\Microsoft\Windows\Recent\AutomaticDestin ations

    zeddy
    •Excel Fancy Goods Chandler
    .
    Last edited by zeddy; 2015-08-18 at 16:41.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •