View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ronnie Ronnie is offline
external usenet poster
 
Posts: 53
Default Transfering files from Open Office Calc to EXCEL

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.
--
Thanks


"Bill Sharpe" wrote:

On 2/8/2010 8:46 AM, Ronnie wrote:
Ron
My aplolgies for the confusion, put it down to computing ignorance.
I have now transferred the OpenOffice files to MS 2007 but when I come to
work on them they open in the OpenOffice format (not MS).
Still don't know if I'm explaining myself fully. If not again my apologies.


How did you "transfer the OOo files to MS 2007"?

I can open an .xlsx (Excel 2007 format) file in OOo 3.1.1, but I cannot
save it in the .xlsx format.

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.

Bill
.