Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel Files from Outlook
Whenever I open an Excel file from Outlook 2003 the name of the file changes.
For example if I'm opening a file with the name test.xls once it opens in Excel is changes the name to test(#).xls. The # number is different on each file. Is there a way to fix this. This is also happening to my PowerPoint files as well. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel Files from Outlook
Right click on the file attachment and chose Save As, otherwise Outlook
creates a temporary file when you open the attachment -- Kevin Backmann "Marilyn" wrote: Whenever I open an Excel file from Outlook 2003 the name of the file changes. For example if I'm opening a file with the name test.xls once it opens in Excel is changes the name to test(#).xls. The # number is different on each file. Is there a way to fix this. This is also happening to my PowerPoint files as well. Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel Files from Outlook
Is there a way to clear those temporary files? I normally open all files
directly from Outlook and it never changed the name of the file. Where are those files stored and how can I clean out that location? Thanks for the quick response! "Kevin B" wrote: Right click on the file attachment and chose Save As, otherwise Outlook creates a temporary file when you open the attachment -- Kevin Backmann "Marilyn" wrote: Whenever I open an Excel file from Outlook 2003 the name of the file changes. For example if I'm opening a file with the name test.xls once it opens in Excel is changes the name to test(#).xls. The # number is different on each file. Is there a way to fix this. This is also happening to my PowerPoint files as well. Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel Files from Outlook
There is a way out for this... This is stored unfortunately in a hidden
system folder. When you open one of these files, go to menu -- File--Properties-- General tab. This gives the document information including the name and the location. Highlight on the location and do a ctrl+c to copy the location and paste the same in the address bar of the windows explorer and hit enter. The location will look something like == "C:\Documents and Settings\admin\Local Settings\Temporary Internet Files\OLK1F6" this will take you directly to the location where these files are stored. if it does not go there on the windows exlporer, go to the menu Tools -- Folder options -- select the dot for "show hidden files or folders" This folder will contain all the files which have been opened through outlook. Normally when you close the mail these attachments are deleted. However if you close the mail without closing the attachment, it does not delete it. then the next time you open the attachment again, it assigns a number to it as a file with the same name is already present. You can safely delete all these files. Trust this meets your requirements. Do post a response if it worked for you. Manoj "Marilyn" wrote: Is there a way to clear those temporary files? I normally open all files directly from Outlook and it never changed the name of the file. Where are those files stored and how can I clean out that location? Thanks for the quick response! "Kevin B" wrote: Right click on the file attachment and chose Save As, otherwise Outlook creates a temporary file when you open the attachment -- Kevin Backmann "Marilyn" wrote: Whenever I open an Excel file from Outlook 2003 the name of the file changes. For example if I'm opening a file with the name test.xls once it opens in Excel is changes the name to test(#).xls. The # number is different on each file. Is there a way to fix this. This is also happening to my PowerPoint files as well. Thanks, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel Files from Outlook
it worked GREAT Manoj!!!
Thank YOU! "Manoj" wrote: There is a way out for this... This is stored unfortunately in a hidden system folder. When you open one of these files, go to menu -- File--Properties-- General tab. This gives the document information including the name and the location. Highlight on the location and do a ctrl+c to copy the location and paste the same in the address bar of the windows explorer and hit enter. The location will look something like == "C:\Documents and Settings\admin\Local Settings\Temporary Internet Files\OLK1F6" this will take you directly to the location where these files are stored. if it does not go there on the windows exlporer, go to the menu Tools -- Folder options -- select the dot for "show hidden files or folders" This folder will contain all the files which have been opened through outlook. Normally when you close the mail these attachments are deleted. However if you close the mail without closing the attachment, it does not delete it. then the next time you open the attachment again, it assigns a number to it as a file with the same name is already present. You can safely delete all these files. Trust this meets your requirements. Do post a response if it worked for you. Manoj "Marilyn" wrote: Is there a way to clear those temporary files? I normally open all files directly from Outlook and it never changed the name of the file. Where are those files stored and how can I clean out that location? Thanks for the quick response! "Kevin B" wrote: Right click on the file attachment and chose Save As, otherwise Outlook creates a temporary file when you open the attachment -- Kevin Backmann "Marilyn" wrote: Whenever I open an Excel file from Outlook 2003 the name of the file changes. For example if I'm opening a file with the name test.xls once it opens in Excel is changes the name to test(#).xls. The # number is different on each file. Is there a way to fix this. This is also happening to my PowerPoint files as well. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help - excel files are not opening | Excel Discussion (Misc queries) | |||
Issue opening csv files in Excel | Excel Discussion (Misc queries) | |||
Excel opening all files in root of C: when launching | Excel Discussion (Misc queries) | |||
Opening Excel files | Excel Discussion (Misc queries) | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) |