Simple clear advice in plain English

Working with Open Office and Microsoft Office

Are Open Office documents compatible with Microsoft Office, and vice versa? We explain

q-a-logo

Q Given that almost everyone uses Word, Powerpoint and Excel to create and share documents, would using Open Office cut people off from the rest of the world, or do documents translate themselves?
John Wallinger

A We are pleased to say that this situation is a lot better than it used to be. Open Office can open documents from all versions of Microsoft Office and save files in the Microsoft formats.

Microsoft Office 2007 can open files from Open Office as long as you have Service Pack 2 for Office installed. This should be offered through Windows Update but it can be found at the Microsoft website if not.

Office 2003 cannot open Open Office documents without a special add-on. Unfortunately the official add-on for Microsoft Office to open Open Office documents is no longer available free of charge.

Instead you can download an alternative. Rather than add Open Office formats to the Open window, there are options available for opening and saving with the ODF format added to the File menu.

Baffled by jargon? See our free online Jargon Buster.

Reader Comments

Open Office Vs Word

I love the idea of Open Office, unfortunately the practice can be a bit rocky. I have spent days trying to work out the page numbering system. Fine if you just want to start from the first page - but if you need to start after a title page, contents, etc., you enter a deep, dark swamp from which there seems no return... If you don't believe me, go to the Open Office forum and type in 'page numbering'. I once tried over nearly two days to work my way through the five or six pages of questions. Over and over the same answer came back from the Moderator, always sending us all back to an answer posted in 2005. If you keep reading you will find that, like me, most of the Seekers had been unable to get The Answer to work. I tried emailing to point out our difficulties but got no reply. Sadly I had to go back to Word 2003. It has its own problems, but the page numbering area doesn't require a PhD.

Posted by BrianA, 12 Sep 2010

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

office-update-illustration

Use Office 2003 to open 2007 documents

Find out how to open files created in Office 2007 and 2010 in an older version of the software

q-a-logo

Use Open Office to open DOCX files

Open and save word processing files in various formats

screenshot-of-neooffice

NeoOffice 3.1.1

OpenOffice suite designed specifically for the Mac

Question & Answer

Q.Why are some of the keys on my keyboard doing strange...

> Read the answer

Q.Is my phone’s Bluetooth any use?

> Read the answer

Q.Can I switch boot drives so that I can work on older...

> Read the answer

Best deals on the web

img

Apple iMac 21.5" (MC309)

£926.40- Buy it now

img

Dell Inspiron 620 ST Intel Core i3-2100 3.10GHz / 3GB / 500GB / DVDRW / Win 7 Home Premium

£329.00- Buy it now

img

ZooStorm 7877-1023

£386.38- Buy it now

Latest issue & subscription deals

Poll

Are you concerned about viruses that target mobile phones?

Jargon Buster

Computing terms explained in plain English

Router

A device used to connect more than one computer or other device to the internet.

Great shopping deals from Computeractive