creating duplicate file

mborek · May 7th, 2002, 07:47 AM

I have a Large Excel file that I work on constantly - When I open this file it automatically opens 2 of the same file (ex. Telephone.xls & Telephone1.xls) it looks like it is automatically creating a backup of the file. I need to know how to delete the second file (because it doesn't show when I browse for it - only when the original file is open it comes up in a different window). It takes forever to save the file because of this and it is happening on my 2 biggest excel files!! Help!!! How do I delete it? And how do I stop it from happening??

Please Help!!

klb · May 7th, 2002, 07:57 AM

You don't have a duplicate file. What you have is two windows open with the same file in both windows.

When the file opens, close one of the windows without saving the file. Now Save and close the remaining window. The next time you open the file, you should have only one version of it.

Good luck

mborek · May 7th, 2002, 08:09 AM

How did this happen to the file?

klb · May 7th, 2002, 08:10 AM

My guess is that at some point a second window was opened and the file was saved with the window open.

mborek · May 7th, 2002, 08:22 AM

I tried what you suggested and it still opens two of this file now it is telephone.xls3. Any other suggestions?

klb · May 7th, 2002, 08:35 AM

Hmmmmm.....
Do you possibly have an auto_open macro that runs when you open the file?

If you disable macros when the file is opened, do you still get extra copies?

mborek · May 7th, 2002, 09:02 AM

It doesn't ask me to disable macro - but I notice when I open this file called AA.xls it opens AA.xls:1 & AA.xls:3. I cannot figure out why and if I try to save file as something else - it does the same thing. saves file name with ( :1 & :3) at end of file name

klb · May 7th, 2002, 09:48 AM

Curiouser and curiouser....

Do you have any modules that might be opening the second window?

If you want, you could send a copy of the file to me in an email.

k

dhbeisner · Nov 23rd, 2005, 11:02 PM

I have the same problem *.xls:1, *.xls:2 etc. When you close xls:2 or 1 they both disappear so there is no opportunity to save the remaining xls:1
And if you rename the file you get xls:1 and xls:2
As usual MSFT help is of no help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 07:47 AM	#1
mborek New Member Join Date: May 2002 Posts: 4	I have a Large Excel file that I work on constantly - When I open this file it automatically opens 2 of the same file (ex. Telephone.xls & Telephone1.xls) it looks like it is automatically creating a backup of the file. I need to know how to delete the second file (because it doesn't show when I browse for it - only when the original file is open it comes up in a different window). It takes forever to save the file because of this and it is happening on my 2 biggest excel files!! Help!!! How do I delete it? And how do I stop it from happening?? Please Help!!

May 7th, 2002, 07:57 AM	#2
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	You don't have a duplicate file. What you have is two windows open with the same file in both windows. When the file opens, close one of the windows without saving the file. Now Save and close the remaining window. The next time you open the file, you should have only one version of it. Good luck

May 7th, 2002, 08:09 AM	#3
mborek New Member Join Date: May 2002 Posts: 4	How did this happen to the file?

May 7th, 2002, 08:10 AM	#4
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	My guess is that at some point a second window was opened and the file was saved with the window open.

May 7th, 2002, 08:22 AM	#5
mborek New Member Join Date: May 2002 Posts: 4	I tried what you suggested and it still opens two of this file now it is telephone.xls3. Any other suggestions?

May 7th, 2002, 08:35 AM	#6
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Hmmmmm..... Do you possibly have an auto_open macro that runs when you open the file? If you disable macros when the file is opened, do you still get extra copies?

May 7th, 2002, 09:02 AM	#7
mborek New Member Join Date: May 2002 Posts: 4	It doesn't ask me to disable macro - but I notice when I open this file called AA.xls it opens AA.xls:1 & AA.xls:3. I cannot figure out why and if I try to save file as something else - it does the same thing. saves file name with ( :1 & :3) at end of file name

May 7th, 2002, 09:48 AM	#8
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Curiouser and curiouser.... Do you have any modules that might be opening the second window? If you want, you could send a copy of the file to me in an email. k

Nov 23rd, 2005, 11:02 PM	#9
dhbeisner New Member Join Date: Nov 2005 Posts: 1	I have the same problem .xls:1, .xls:2 etc. When you close xls:2 or 1 they both disappear so there is no opportunity to save the remaining xls:1 And if you rename the file you get xls:1 and xls:2 As usual MSFT help is of no help!