Office 2007 Compatibility Issues – ‘This is a pre-release version of the Compatibility Pack and can open pre-release Office 2007 files only. Do you want to check for a newer version of the Compatibility Pack?’

Problem: When you try opening an Word 2007 file in 2003 using compatibility pack, you will be shown the error ‘This is a pre-release version of the Compatibility Pack and can open pre-release Office 2007 files only. Do you want to check for a newer version of the Compatibility Pack?’. Cause: Files created other than […]

Office 2007 Compatibility Issues – _xlfn prefix error in Excel 2003

Problem: When you try opening and Excel 2007 file in earlier version of Excel, you will notice an _xlfn prefix is displayed in front of a function in a formula. When the formula is calculated, it displays the #NAME? error value. Cause: Microsoft Office Excel workbook contains a function that is not supported in the […]

Office 2007 Compatibility Issues – Uninitialized ActiveX controls will not be opened in this version of Excel

I have been working with Office migration from version 2003 to 2007/2010. I faced quite a few problems in my earlier stages and it took lot of time to figure out the exact solution for some simple problems. So, thought it would be useful for someone who also involved in the migration. Problem: Macro enabled […]