View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default Transfering files from Open Office Calc to EXCEL

On 2/9/2010 9:01 AM, Ronnie wrote:
Bill
Not sure if my first reply went off OK, so If it did my apologies (seems as
though I am forever apologising!) This is what I wrote.

To make sure I didn't lose my file/s I copied them from OOo into MS2007.
They copied OK so now I want to dump the OO programme. Unfortuately when I
try and open the file/s with MS 2007 the file/s open in the OO format (OO
tool bar, message bar, commands etc) which means I can't work on them with
any of the MS2007 features.


To repeat:
If you want compatability between OOo and Excel, save your Excel files
in Excel 97-2003 format while running Excel. OOo easily handles such files.

Conversely, Excel does not recognize OOo files. You can save these files
in OOo as an .xls file, which can then be opened in OOo.

You cannot just copy files from OOo to Excel 2007 using the OOo
extensions, as you indeed have learned.

Once you've got all of your OOo files saved in an Excel format you can
then open them in Excel 2007. After that you can remove OOo using
Add/Remove Programs.

Bill