convert quattro pro 11 files to excel 2003
We have switched to Excel 2003 at the office and I have to convert many
Quattro Pro version 11 files to Excel ... is there a conversion tool available that will work? I have tried to save them as excel ver 97 files within Quattro pro 11, but the program will not save the formulas, only the values. any help is appreciated. thanks. THF |
convert quattro pro 11 files to excel 2003
With both a Quattro Pro window and an Excel window open, have you tried
to copy & paste from one to the other? Then you could save the Excel file directly. I don't know how many you mean by "many" files, but if this is a lot then it could take some time, I'm afraid. Hope this helps. Pete |
convert quattro pro 11 files to excel 2003
Thanks for answering Pete. Many = roughly 500 :(
I wish to convert the file to keep the formulas. Correct me if I am wrong, but if I copy/paste, won't I get errors whereas excel will not recognize the @formulas ?? I think I may have found a solution in other posts where I should download Corel Office 12 trial version which contains a converter to Excel 2003... I will try this and cross my fingers. thanks again. "Pete" wrote: With both a Quattro Pro window and an Excel window open, have you tried to copy & paste from one to the other? Then you could save the Excel file directly. I don't know how many you mean by "many" files, but if this is a lot then it could take some time, I'm afraid. Hope this helps. Pete |
convert quattro pro 11 files to excel 2003
If you still have Quattro Pro available, try saving the Quattro Pro as a
Lotus 1-2-3 file and then open the Lotus version of your Quattro file in Excel. If that works, do a File/Save As and change the file type to the Excel workbook flavor of your choice. -- Kevin Backmann "THF" wrote: Thanks for answering Pete. Many = roughly 500 :( I wish to convert the file to keep the formulas. Correct me if I am wrong, but if I copy/paste, won't I get errors whereas excel will not recognize the @formulas ?? I think I may have found a solution in other posts where I should download Corel Office 12 trial version which contains a converter to Excel 2003... I will try this and cross my fingers. thanks again. "Pete" wrote: With both a Quattro Pro window and an Excel window open, have you tried to copy & paste from one to the other? Then you could save the Excel file directly. I don't know how many you mean by "many" files, but if this is a lot then it could take some time, I'm afraid. Hope this helps. Pete |
convert quattro pro 11 files to excel 2003
Actually, you can type an @formula directly into an Excel cell and it
will recognise it and convert it to =formula. You might get problems if you had formulae which referred to other sheets in the QPro file, as these would point back to that file - however, you could do Find and Replace afterwards to get rid of all the links to the other file. Anyway, I think getting Corel Office 12 on trial is a good solution. Cheers, Pete |
All times are GMT +1. The time now is 10:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com