Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
.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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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" 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
Where is the "Convert" option? I do not see it in Office 2007 Ultimate.
Tyro "Jon Peltier" wrote in message ... 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" 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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" wrote: Where is the "Convert" option? I do not see it in Office 2007 Ultimate. Tyro "Jon Peltier" wrote in message ... 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" 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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 "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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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. "Tyro" wrote in message . net... 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 "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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls files not deleted after conversion to .xlsx; help please
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: 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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
format converter
I came across an amazing site which converts xlsx to xls in seconds and its free, http://www.sheetconvert.com
Do try that |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
format converter
But you can do this with SaveAs in XL2007
And Microsoft has a converter for users of pre-2007 versions best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email <Nisha wrote in message ... I came across an amazing site which converts xlsx to xls in seconds and its free, http://www.sheetconvert.com Do try that |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
unzip/zip xlsx files | Excel Discussion (Misc queries) | |||
how i open xlsx files | Excel Discussion (Misc queries) | |||
HOW DO I CONVERT XLSX FILES BACK TO EXCEL 2003? | Excel Discussion (Misc queries) | |||
modify xlsx files with excel 2003 | Excel Discussion (Misc queries) |