Cannot open files in Most Recently Used List
 

When I use the menu's "File | Recently used file list" to open say,
Product_List..xls, I get "C:\Documents and Settings\UserName\Local
Settings\Temporary Internet Files\OLK70\Product_List.xls could not be found."
I get this even for locally saved files.

How can I get Excel to open the most recently saved version of Product_List?
Windows XP Start Menu-Documents opens the version I saved, how do I get
Excel to do this?

Thanks,

Suzan

Cannot open files in Most Recently Used List
 

Suzan wrote:

When I use the menu's "File | Recently used file list" to open say,
Product_List..xls, I get "C:\Documents and Settings\UserName\Local
Settings\Temporary Internet Files\OLK70\Product_List.xls could not be found."
I get this even for locally saved files.

How can I get Excel to open the most recently saved version of Product_List?
Windows XP Start Menu-Documents opens the version I saved, how do I get
Excel to do this?

Thanks,

Suzan

Hi Suzan

That path suggets to me that you've opened a file from an e-mail and
not saved it anywhere else.

Can you navigate to where you think the file is saved via File Open
and open it?

Regards

Steve

Cannot open files in Most Recently Used List
 

That's it.
Thanks,
Suzan

" wrote:


Suzan wrote:

When I use the menu's "File | Recently used file list" to open say,
Product_List..xls, I get "C:\Documents and Settings\UserName\Local
Settings\Temporary Internet Files\OLK70\Product_List.xls could not be found."
I get this even for locally saved files.

How can I get Excel to open the most recently saved version of Product_List?
Windows XP Start Menu-Documents opens the version I saved, how do I get
Excel to do this?

Thanks,

Suzan

Hi Suzan

That path suggets to me that you've opened a file from an e-mail and
not saved it anywhere else.

Can you navigate to where you think the file is saved via File Open
and open it?

Regards

Steve

Cannot open files in Most Recently Used List
 

Hi Susan. Don't know if you want to go this route, but here's an option
if you want.
One option is to add a tool bar button to Excel that runs a "SaveAs" macro.
The "SaveAs" method has the option to add the file to the "Most Recently
Used (MRU)" list.

ActiveWorkbook.SaveAs Filename:="MyFileName", AddToMru:=True

Again, just an idea...
HTH
Dana DeLouis


Suzan wrote:
That's it.
Thanks,
Suzan

" wrote:

Suzan wrote:

When I use the menu's "File | Recently used file list" to open say,
Product_List..xls, I get "C:\Documents and Settings\UserName\Local
Settings\Temporary Internet Files\OLK70\Product_List.xls could not be found."
I get this even for locally saved files.

How can I get Excel to open the most recently saved version of Product_List?
Windows XP Start Menu-Documents opens the version I saved, how do I get
Excel to do this?

Thanks,

Suzan
Hi Suzan

That path suggets to me that you've opened a file from an e-mail and
not saved it anywhere else.

Can you navigate to where you think the file is saved via File Open
and open it?

Regards

Steve