.xls files not deleted after conversion to .xlsx; help please


T

Tschurin

I have read that when I convert an .xls workbook to .xlsx, Excel will
automatically delete the older version. It is not working that way for me;
the old .xls file is still there in the file directory, along with the newer
..xlsx version, even after I “refresh†Windows explorer. Any suggestions as to
why the old .xls files are not being deleted automatically post-conversion; I
have thousands of older files and would hate to have to delete each one of
them manually when I convert a workbook to Excel 2007. I believe the older
files were mostly created in Excel 2000. Oddly enough the automatic deletion
is working fine with my Word 2007 after I convert a .doc file to .docx.
Thanks in advance for any help you can give me.
 
Ad

Advertisements

J

Jon Peltier

Since it's a Save As operation, I would not have expected the old file to be
deleted.

- Jon
 
T

Tyro

Word 2007 does not delete the .doc file when you open it and save it as a
..docx file. Neither does Excel 2007 delete the .xls file when you open it
and save it as a .docx file.

Tyro
 
T

Tyro

Correction:

Word 2007 does not delete the .doc file when you open it and save it as a
..docx file. Neither does Excel 2007 delete the .xls file when you open it
and save it as a .xlsx file.
 
T

Tschurin

Jon and Tyro

Obviously I have only limited knowledge of this stuff but I don't "save as"
to convert. I click on the office button in the upper left hand corner and
there is a "convert" option [distinct from the "save" or "save as" options].
And yes, when I'm using a .doc file in Word 2007 and click on convert and
then close the file, it shows up in the directory with a .docx extension.
There is only one file with that name. In Excel, I do the same thing and the
result is two files with the same name, one with an .xls extension and the
other with an .xlsx extension.
 
T

Tyro

I see no "Convert" option in my Office 2007 Ulitmate. The options I see when
clicking on the Office Button are: New, Open, Save, Save As, Print,
Prepare, Send, Publish, Business Contact Manger,. Close. Please enlighten me
as to where "Convert" is.

Tyro


Tschurin said:
Jon and Tyro

Obviously I have only limited knowledge of this stuff but I don't "save
as"
to convert. I click on the office button in the upper left hand corner and
there is a "convert" option [distinct from the "save" or "save as"
options].
And yes, when I'm using a .doc file in Word 2007 and click on convert and
then close the file, it shows up in the directory with a .docx extension.
There is only one file with that name. In Excel, I do the same thing and
the
result is two files with the same name, one with an .xls extension and the
other with an .xlsx extension.

--
Geoff


Jon Peltier said:
Since it's a Save As operation, I would not have expected the old file to
be
deleted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
 
Ad

Advertisements

J

Jon Peltier

Well, I decided to shut up and see what happens. I opened Office 2003 files
and converted them to Office 2007 files. In *both* Excel and Word, the 2003
format file was removed after the 2007 file was created.

I realized that I've never used the convert button, at least not since
losing macros in a file while testing the beta. Since my files often contain
macros, I do Save As to ensure that I get a macro-enabled file (.xlsm or
..docm). This of course leaves the original file intact.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Tschurin said:
Jon and Tyro

Obviously I have only limited knowledge of this stuff but I don't "save
as"
to convert. I click on the office button in the upper left hand corner and
there is a "convert" option [distinct from the "save" or "save as"
options].
And yes, when I'm using a .doc file in Word 2007 and click on convert and
then close the file, it shows up in the directory with a .docx extension.
There is only one file with that name. In Excel, I do the same thing and
the
result is two files with the same name, one with an .xls extension and the
other with an .xlsx extension.

--
Geoff


Jon Peltier said:
Since it's a Save As operation, I would not have expected the old file to
be
deleted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
 
T

Tyro

Where is the "Convert" option? I do not see it in Office 2007 Ultimate.

Tyro

Jon Peltier said:
Well, I decided to shut up and see what happens. I opened Office 2003
files and converted them to Office 2007 files. In *both* Excel and Word,
the 2003 format file was removed after the 2007 file was created.

I realized that I've never used the convert button, at least not since
losing macros in a file while testing the beta. Since my files often
contain macros, I do Save As to ensure that I get a macro-enabled file
(.xlsm or .docm). This of course leaves the original file intact.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Tschurin said:
Jon and Tyro

Obviously I have only limited knowledge of this stuff but I don't "save
as"
to convert. I click on the office button in the upper left hand corner
and
there is a "convert" option [distinct from the "save" or "save as"
options].
And yes, when I'm using a .doc file in Word 2007 and click on convert and
then close the file, it shows up in the directory with a .docx extension.
There is only one file with that name. In Excel, I do the same thing and
the
result is two files with the same name, one with an .xls extension and
the
other with an .xlsx extension.

--
Geoff


Jon Peltier said:
Since it's a Save As operation, I would not have expected the old file
to be
deleted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


I have read that when I convert an .xls workbook to .xlsx, Excel will
automatically delete the older version. It is not working that way for
me;
the old .xls file is still there in the file directory, along with the
newer
.xlsx version, even after I "refresh" Windows explorer. Any
suggestions as
to
why the old .xls files are not being deleted automatically
post-conversion; I
have thousands of older files and would hate to have to delete each
one of
them manually when I convert a workbook to Excel 2007. I believe the
older
files were mostly created in Excel 2000. Oddly enough the automatic
deletion
is working fine with my Word 2007 after I convert a .doc file to
.docx.
Thanks in advance for any help you can give me.
 
T

Tschurin

Click the office symbol in the upper left hand corner. You must have open at
the time a file that would need conversion. Otherwise I don't think the
"convert" option will appear on the menu.
--
Geoff


Tyro said:
Where is the "Convert" option? I do not see it in Office 2007 Ultimate.

Tyro

Jon Peltier said:
Well, I decided to shut up and see what happens. I opened Office 2003
files and converted them to Office 2007 files. In *both* Excel and Word,
the 2003 format file was removed after the 2007 file was created.

I realized that I've never used the convert button, at least not since
losing macros in a file while testing the beta. Since my files often
contain macros, I do Save As to ensure that I get a macro-enabled file
(.xlsm or .docm). This of course leaves the original file intact.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Tschurin said:
Jon and Tyro

Obviously I have only limited knowledge of this stuff but I don't "save
as"
to convert. I click on the office button in the upper left hand corner
and
there is a "convert" option [distinct from the "save" or "save as"
options].
And yes, when I'm using a .doc file in Word 2007 and click on convert and
then close the file, it shows up in the directory with a .docx extension.
There is only one file with that name. In Excel, I do the same thing and
the
result is two files with the same name, one with an .xls extension and
the
other with an .xlsx extension.

--
Geoff


:

Since it's a Save As operation, I would not have expected the old file
to be
deleted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


I have read that when I convert an .xls workbook to .xlsx, Excel will
automatically delete the older version. It is not working that way for
me;
the old .xls file is still there in the file directory, along with the
newer
.xlsx version, even after I "refresh" Windows explorer. Any
suggestions as
to
why the old .xls files are not being deleted automatically
post-conversion; I
have thousands of older files and would hate to have to delete each
one of
them manually when I convert a workbook to Excel 2007. I believe the
older
files were mostly created in Excel 2000. Oddly enough the automatic
deletion
is working fine with my Word 2007 after I convert a .doc file to
.docx.
Thanks in advance for any help you can give me.
 
J

Jon Peltier

Convert is only present if the active document is an older version.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Tyro said:
I see no "Convert" option in my Office 2007 Ulitmate. The options I see
when clicking on the Office Button are: New, Open, Save, Save As, Print,
Prepare, Send, Publish, Business Contact Manger,. Close. Please enlighten
me as to where "Convert" is.

Tyro


Tschurin said:
Jon and Tyro

Obviously I have only limited knowledge of this stuff but I don't "save
as"
to convert. I click on the office button in the upper left hand corner
and
there is a "convert" option [distinct from the "save" or "save as"
options].
And yes, when I'm using a .doc file in Word 2007 and click on convert and
then close the file, it shows up in the directory with a .docx extension.
There is only one file with that name. In Excel, I do the same thing and
the
result is two files with the same name, one with an .xls extension and
the
other with an .xlsx extension.

--
Geoff


Jon Peltier said:
Since it's a Save As operation, I would not have expected the old file
to be
deleted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


I have read that when I convert an .xls workbook to .xlsx, Excel will
automatically delete the older version. It is not working that way for
me;
the old .xls file is still there in the file directory, along with the
newer
.xlsx version, even after I "refresh" Windows explorer. Any
suggestions as
to
why the old .xls files are not being deleted automatically
post-conversion; I
have thousands of older files and would hate to have to delete each
one of
them manually when I convert a workbook to Excel 2007. I believe the
older
files were mostly created in Excel 2000. Oddly enough the automatic
deletion
is working fine with my Word 2007 after I convert a .doc file to
.docx.
Thanks in advance for any help you can give me.
 
J

Jon Peltier

That's correct. I noticed that after I converted a document, the convert
button disappeared.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Tschurin said:
Click the office symbol in the upper left hand corner. You must have open
at
the time a file that would need conversion. Otherwise I don't think the
"convert" option will appear on the menu.
--
Geoff


Tyro said:
Where is the "Convert" option? I do not see it in Office 2007 Ultimate.

Tyro

Jon Peltier said:
Well, I decided to shut up and see what happens. I opened Office 2003
files and converted them to Office 2007 files. In *both* Excel and
Word,
the 2003 format file was removed after the 2007 file was created.

I realized that I've never used the convert button, at least not since
losing macros in a file while testing the beta. Since my files often
contain macros, I do Save As to ensure that I get a macro-enabled file
(.xlsm or .docm). This of course leaves the original file intact.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Jon and Tyro

Obviously I have only limited knowledge of this stuff but I don't
"save
as"
to convert. I click on the office button in the upper left hand corner
and
there is a "convert" option [distinct from the "save" or "save as"
options].
And yes, when I'm using a .doc file in Word 2007 and click on convert
and
then close the file, it shows up in the directory with a .docx
extension.
There is only one file with that name. In Excel, I do the same thing
and
the
result is two files with the same name, one with an .xls extension and
the
other with an .xlsx extension.

--
Geoff


:

Since it's a Save As operation, I would not have expected the old
file
to be
deleted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


I have read that when I convert an .xls workbook to .xlsx, Excel
will
automatically delete the older version. It is not working that way
for
me;
the old .xls file is still there in the file directory, along with
the
newer
.xlsx version, even after I "refresh" Windows explorer. Any
suggestions as
to
why the old .xls files are not being deleted automatically
post-conversion; I
have thousands of older files and would hate to have to delete each
one of
them manually when I convert a workbook to Excel 2007. I believe
the
older
files were mostly created in Excel 2000. Oddly enough the automatic
deletion
is working fine with my Word 2007 after I convert a .doc file to
.docx.
Thanks in advance for any help you can give me.
 
Ad

Advertisements

S

Sebastian Asplund

I have the same problem when i open a file from the network, but not when i
open a file from a local harddrive or usb-flashdrive.



"Tschurin" skrev:
 
Ad

Advertisements

B

Bernard Liengme

But you can do this with SaveAs in XL2007
And Microsoft has a converter for users of pre-2007 versions
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top