Missing Recently opened Files

[elbergeron]

I'm having a problem with my Excel 2000. My recently opened workbooks don't always show up in the list under "File", even though I've checked off to show the last 9 opened. The odd thing is that some of them do! It almost seems that if they are in sub-directories, they are no-shows, any help?

Lance

 

[Dreamboat]

Likely, your Excel is not shutting down properly when you close it.

Anne Troy
Killer Coder Live Chat!

http://www.vbaexpress.com/forum/showthread.php?p=2121

 

[elbergeron]

No, it shuts down fine, I've recently up(down)graded to Windows XP Home. [cencored]

 

[fumei]

1. Sub-directories? Could you please, as much as possible, elaborate on that? Why do you think so? Can you test this by opening some files in various folders?

2. Have any of the missing files been opened through Outlook (ie. opening them as an attachment)?

Gerry

 

[elbergeron]

Hi Gerry, here's the scoop. The files are located in:

C:\Documents & Settings\User\My Documents\Timesheets\Timesheets 2004\Timesheets 06-2004\*.xls

When I open a file in the Timesheets 06-2004\ directory, while I am working on it, it shows up as Line 1 in the recently opened as 1 BC Timesheet Summary 06192004.xls

Below it are the other 8 "recently" opened. Once I save my work and re-open excel, Line 1 is now what appeared on line 2 in the Recently opened, etc.

If I open a file any directory earlier, eg \Timesheets\Lance.xls or \Timesheets 2004\Lance Expense June.xls, The file stays in the Recently opened list.

I guess I'm too sub-catagorized for Excel!?!

Could you please try the same so I know I'm not bonkers?

Thanks, Lance