I deleted all old files from my documents folder but all still shows up at
Recent Documents when opening Excel. Any Ideas?

Sure, I can help you with that! Here are the steps to remove a file from the Recent Documents list in Excel 2007:

1. Open Excel 2007.
2. Click on the Office button in the top left corner of the screen.
3. Click on the Excel Options button at the bottom of the menu.
4. In the Excel Options window, click on the Advanced tab.
5. Scroll down to the Display section and find the option for "Show this number of Recent Documents".
6. Change the number to 0 (zero) and click OK.
7. Close Excel and reopen it.
8. Go back to the Excel Options window and change the number of Recent Documents back to the desired amount (e.g. 10).
9. Close Excel again and reopen it.
10. The list of Recent Documents should now be cleared and only show files that have been recently opened.

If you want to remove a specific file from the Recent Documents list without clearing the entire list, you can do the following:

1. Open Excel 2007.
2. Click on the Office button in the top left corner of the screen.
3. Find the file you want to remove from the Recent Documents list.
4. Right-click on the file and select "Remove from list".
5. The file should now be removed from the Recent Documents list.

GPS wrote:
I deleted all old files from my documents folder but all still shows up at
Recent Documents when opening Excel. Any Ideas?


Recent documents is just a folder. You can remove the links by openning
up the recent files folder and deleting the links.


To clear the My Recent Documents list, follow these steps:
1. Right-click Start, and then click Properties. Or, if the Start menu
is already displayed, right-click an empty area of the Start menu, and
then click Properties.
2. Click Customize.
3. Click the Advanced tab.
4. Under Recent documents, click Clear List, click OK, and then click
OK. Your most recently used documents are removed from the My Recent
Documents folder. Note that this action does not delete the documents
from your hard disk.




Brad
http://www.pcast.com

Excel 2007's MRU list is kept in the registry he

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\File MRU

You can easily delete them all but picking among them is tedious (with
REGEDIT). Someone should write a script to do that!

--
Jim
"GPS" wrote in message
...
|I deleted all old files from my documents folder but all still shows up at
| Recent Documents when opening Excel. Any Ideas?

Thanks Jim,

Very Good!

=============================

"Jim Rech" wrote:

Excel 2007's MRU list is kept in the registry he

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\File MRU

You can easily delete them all but picking among them is tedious (with
REGEDIT). Someone should write a script to do that!

--
Jim
"GPS" wrote in message
...
|I deleted all old files from my documents folder but all still shows up at
| Recent Documents when opening Excel. Any Ideas?

Office ButtonAdvancedDisplayShow this number of Recent Documents
Set to 0 (zero)

Works everytime.

"Brad" wrote:

GPS wrote:
I deleted all old files from my documents folder but all still shows up at
Recent Documents when opening Excel. Any Ideas?


Recent documents is just a folder. You can remove the links by openning
up the recent files folder and deleting the links.


To clear the My Recent Documents list, follow these steps:
1. Right-click Start, and then click Properties. Or, if the Start menu
is already displayed, right-click an empty area of the Start menu, and
then click Properties.
2. Click Customize.
3. Click the Advanced tab.
4. Under Recent documents, click Clear List, click OK, and then click
OK. Your most recently used documents are removed from the My Recent
Documents folder. Note that this action does not delete the documents
from your hard disk.




Brad
http://www.pcast.com