Excel annoyance

When I open Excel and click the 'File' menu item, a drop-down list of most
recently used files appears, as is normal in Windows programs. In Excel
however the list is usually wrong. It usually omits the files which I have
used most recently and lists only ones which I used some time previously.
The problem never happens in other Windows programs. Is this a peculiarity
of Excel? and is there a fix for it?

Windows XP Pro, Excel 2000.

:-\

John

MartinW
Tue Jul 11 04:44:46 CDT 2006

Hi John,

If you are using files that you are not saving then they won't
show on the list.
The 'recently used files' list should actually read 'last files saved list'.

HTH
Martin

John
Tue Jul 11 05:17:19 CDT 2006


"MartinW" <mtmw@hotmail.invalid> wrote in message
news:e36dm6MpGHA.1592@TK2MSFTNGP04.phx.gbl...
> Hi John,
>
> If you are using files that you are not saving then they won't
> show on the list.
> The 'recently used files' list should actually read 'last files saved
> list'.
>
> HTH
> Martin


No Martin that's not the problem. I just tried it to check, and the file I
edited/saved does not show up on the list.

Any other suggestions?

John

MartinW
Tue Jul 11 06:23:22 CDT 2006

Hi John,

Unfortunately, I can't think of anything other than a reinstall which
is a bit drastic. Hang in there for a while and hopefully someone
else will come up with something more constructive.

Regards
Martin

Gord
Tue Jul 11 09:24:16 CDT 2006

John

I have never used Excel 2000 but in Excel 97, if you opened a workbook from a
shortcut or from within Windows Explorer, those files would not appear on the
MRU list on the File menu.

Those opened from File>Open would show on the MRU list.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 08:32:15 GMT, "John Rampling" <John@NOSPAM.com> wrote:

>When I open Excel and click the 'File' menu item, a drop-down list of most
>recently used files appears, as is normal in Windows programs. In Excel
>however the list is usually wrong. It usually omits the files which I have
>used most recently and lists only ones which I used some time previously.
>The problem never happens in other Windows programs. Is this a peculiarity
>of Excel? and is there a fix for it?
>
>Windows XP Pro, Excel 2000.
>
>:-\
>
>John
>
>

The
Tue Jul 11 09:45:33 CDT 2006

Are you closing excel properly, I find if i dont close programs in the
proper manner then the last files i were using at the time dont show...

Not sure if this will help or not but thought Id try and help.

"John Rampling" <John@NOSPAM.com> wrote in message
news:PUKsg.23252$1g.10368@newsfe1-win.ntli.net...
>
> "MartinW" <mtmw@hotmail.invalid> wrote in message
> news:e36dm6MpGHA.1592@TK2MSFTNGP04.phx.gbl...
>> Hi John,
>>
>> If you are using files that you are not saving then they won't
>> show on the list.
>> The 'recently used files' list should actually read 'last files saved
>> list'.
>>
>> HTH
>> Martin
>
>
> No Martin that's not the problem. I just tried it to check, and the file I
> edited/saved does not show up on the list.
>
> Any other suggestions?
>
> John
>

John
Tue Jul 11 10:28:45 CDT 2006

Gord I think you're on to something. I tried it and it's just as you say.

Now, any theories as to why this should happen in Excel, but not in any
other application?

John Rampling



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:4vc7b294vnfa8hj626j91kjbumnf4u5fnk@4ax.com...
> John
>
> I have never used Excel 2000 but in Excel 97, if you opened a workbook
> from a
> shortcut or from within Windows Explorer, those files would not appear on
> the
> MRU list on the File menu.
>
> Those opened from File>Open would show on the MRU list.
>
>
> Gord Dibben MS Excel MVP
>

Gord
Tue Jul 11 10:46:13 CDT 2006

John

I do not remember getting any explanation, but that doesn't mean there isn't
one.

All I know is........when I moved from XL97 to XL2002 and 2003 the behaviour
went away.

Any file opened by any means at all will show on the MRU

File>New but not saved, do not show on the MRU


Gord

On Tue, 11 Jul 2006 15:28:45 GMT, "John Rampling" <John@NOSPAM.com> wrote:

>Gord I think you're on to something. I tried it and it's just as you say.
>
>Now, any theories as to why this should happen in Excel, but not in any
>other application?
>
>John Rampling
>
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:4vc7b294vnfa8hj626j91kjbumnf4u5fnk@4ax.com...
>> John
>>
>> I have never used Excel 2000 but in Excel 97, if you opened a workbook
>> from a
>> shortcut or from within Windows Explorer, those files would not appear on
>> the
>> MRU list on the File menu.
>>
>> Those opened from File>Open would show on the MRU list.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>

Jim
Tue Jul 11 10:48:50 CDT 2006

Here is a link to the post that shows the vba code I use to add open
workbooks to the file listing and remove any deleted or relocated files...
http://tinyurl.com/owguj
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"John Rampling" <John@NOSPAM.com> wrote in message news:jmJsg.95354$uP.52969@newsfe2-gui.ntli.net...
When I open Excel and click the 'File' menu item, a drop-down list of most
recently used files appears, as is normal in Windows programs. In Excel
however the list is usually wrong. It usually omits the files which I have
used most recently and lists only ones which I used some time previously.
The problem never happens in other Windows programs. Is this a peculiarity
of Excel? and is there a fix for it?

Windows XP Pro, Excel 2000.

:-\

John

Jim
Tue Jul 11 11:03:25 CDT 2006

That's the way it is explanation from MS...
http://support.microsoft.com/kb/166880/en-us
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"John Rampling" <John@NOSPAM.com>
wrote in message
When I open Excel and click the 'File' menu item, a drop-down list of most
recently used files appears, as is normal in Windows programs. In Excel
however the list is usually wrong. It usually omits the files which I have
used most recently and lists only ones which I used some time previously.
The problem never happens in other Windows programs. Is this a peculiarity
of Excel? and is there a fix for it?

Windows XP Pro, Excel 2000.
:-\
John

Gord
Tue Jul 11 11:20:36 CDT 2006

Thanks for the URL Jim.

Gord

On Tue, 11 Jul 2006 09:03:25 -0700, "Jim Cone" <jim.coneXXX@rcn.comXXX> wrote:

>That's the way it is explanation from MS...
>http://support.microsoft.com/kb/166880/en-us

Gord Dibben MS Excel MVP