Compatibility between Excel 2002 as part of Office XP and XLSX

**filky** · 01-25-2013, 08:24 AM

Hi,

Probably a basic question, but can anyone confirm that if you have Excel 2002 and the Microsoft Office Compatibility Pack installed that you can only use this for opening XLSX files and then saving them in the same XLSX format? Or is it possible to take an XLS file created with Excel 2002 and save this as an XLSX using only the compatibility pack too?

I read here : Compatibility Pack that you will be able to open, edit, and save files using the newer formats but not that you can actually convert them.

Thank you for any advice, or confirmation.

Regards

Paul

**HaHoBe** · 01-26-2013, 06:15 AM

Hi, Paul,

as I could only check this issue with Excel2003 I have to trust that Excel2002/XP behaves the same way: you can save any xls (existing or new) as xlsx, xlsb or xlsm but due to the limitations concerning Conditional Formatting, Autofilter, Formulas, Pivot Tables: it will only show what´s available in the version that saves, not the one of the format you save in (2007/2010). And for not mistaking anything I generally leave the older files in the format they were originally created with.

A newly created and saved Workbook as xlsx with 2003 showed the proper number of rows and columns when opened with 2010.

HTH,
Holger

Compatibility between Excel 2002 as part of Office XP and XLSX

LinkBack

Thread Tools

Rate This Thread

Display

Compatibility between Excel 2002 as part of Office XP and XLSX

Re: Compatibility between Excel 2002 as part of Office XP and XLSX

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions