Excel change filename on open

April 9, 2009 at 04:17:10
Specs: Windows Vista
Whenever i open the Ms Excel files, it will help me to add 1 behind the file name. For example testing.xls ,it will change to testing1.xls.

When I close excel, and open the file again, it will show testing2.xls. How many time i open and close the file, it will put a sequence number beninh the files name.

Can you all outside there, please help me to solve this problem..

Thanks you so much

See More: Excel change filename on open

Report •

April 9, 2009 at 04:22:08
additonal info: this only happens when the excel is openend from Outlook when opening a attachment in a mail.

Although the file in the attachment hasd as name A.XLS,
the first mail with this file will open as A.XLS, then close excel, and then the second mail with the same attachment will open as A.XLS (2), and so on.


Report •

April 9, 2009 at 05:47:20
After you open the file, click File Save As and check the window that opens.

If I understand the process correctly, Outlook detaches and saves the file to a temp directory before it opens it. For example on my machine, the current location is C:\...Temporary Internet Files\OLK5

If the previous file e.g. A.xls is still in that folder, Outlook wil save the next A.xls as A (2).xls so that it doesn't overwrite the existing file.

As far as I know, the only ways to stop getting the (2) etc. is to either manually rename/delete the file in the temp directory or quit Outlook so it clears the directory itself.

Report •

April 9, 2009 at 06:36:44

sounds like a good explanation! Thanks!

Should there really be no other way to get arround this?


Report •

Related Solutions

April 9, 2009 at 08:03:24
seems like the 'temp' files are gone after shutdown...

Report •

April 9, 2009 at 08:42:07
re:seems like the 'temp' files are gone after shutdown...

On my machine, Outlook typically cleans up the directory each time I quit the application, so if you mean "shutdown" of Outlook, yes. If you mean shutdown of your system, that seems like overkill.

Report •

Ask Question