View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default .xls files not deleted after conversion to .xlsx; help please

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" wrote in message
...
I see no "Convert" option in my Office 2007 Ulitmate. The options I see
when clicking on the Office Button a New, Open, Save, Save As, Print,
Prepare, Send, Publish, Business Contact Manger,. Close. Please enlighten
me as to where "Convert" is.

Tyro


"Tschurin" wrote in message
...
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" wrote:

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
_______


"Tschurin" wrote in message
...
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.

--
Geoff