Office 2010

brian076

I bought a Dell laptop in January and it came with MS Starter. I saved documents using this and they all have the .ods extension. I've recently bought MS Office 2010 and I'm not sure if it's possible to convert these docs to Office 2010. When I go to Save As there's no Office 2010 option.
Anyone any ideas?

Thoie

Copy and paste the content into a new Word doc? It's very weird that the Office Starter was saving as .ods by default.

You could also try making a copy of the .ods file, and then changing the extension to .doc (on the copy) and see what that does.

If the contents aren't private, you could put one up here and I'll give it a try if you like.

Dulchie

.ods is the openoffice/libreoffice spreadsheet extension.
Are your files spreadsheets?

If so simply save as .xlsx (for Office 2007/2010) or .xls for previous versions

brian076

Hi thanks for the replies. I've tried opening the spreadsheet in Excel Starter then copying and pasting it to a blank MS Office spreadsheet, and the screen shot below is what I get.

yoyo

I think its a legal thing, ods is the openoffice open format while xlsx is Microsofts open one. I think some anti trust EU thing meant Microsoft have to ask you when launching office for the first time which format to choose. To op you should be able to open the ods file in Excel 2010 (change the file type dropdown in the open file command to all files) and then you can save as xlsx if you wish, ods is a spreadsheet file btw, not text!

Nick

Thoie

Another suggestion is to open the file in Google docs, then save as Excel from there.

brian076

Thanks for the suggestions but still no luck. Tried saving it as an xls file and also uploaded it in Google Docs and downloaded it in Excel, but I still get the same screen as before (see Screenshot).
Not sure if this is relevant but the option to download from Google Docs only gives the option of Excel 97-2003, there's no Excel 2010.

Thoie

brian076 wrote: »

Thanks for the suggestions but still no luck. Tried saving it as an xls file and also uploaded it in Google Docs and downloaded it in Excel, but I still get the same screen as before (see Screenshot).
Not sure if this is relevant but the option to download from Google Docs only gives the option of Excel 97-2003, there's no Excel 2010.

Even if it was saved as Excel 97-2003, Office 2010 would open it. I presume you still have the original files, and have been trying all these things on copies?

Did you open the file in Google docs and see it working ok there?

brian076

Ok I've sorted it. saved old doc as Excel Worksheet then "Opened With" Excel in Office and seems to work fine. Thanks for all your help