Cannot open files in Most Recently Used List

S

Suzan

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
 
B

britwiz

Suzan said:
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
Click to expand...

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
 
S

Suzan

That's it.
Thanks,
Suzan

[email protected] said:
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
Click to expand...
 
D

Dana DeLouis

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
 
Top