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 […]

40 Deadly Shortcut Keys in Excel

Key What it does Home Beginning of the row CTRL+Home Beginning of the region CTRL+End End of the region Shift + F11 Insert new worksheet Ctrl+Enter Fill the selected cell with current entry Ctrl+Delete Delete till end of line Ctrl+Delete Fill down Ctrl+R Fill right Ctrl+F3 Define a name Shift + F3 Paste a function […]

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 […]

VLookup Function

Function Description: Vlookup stands for ‘Vertical’ lookup. This function searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. Syntax: VLookup(lookup_value, table_array, column_index_number, range_lookup) in simpler terms we can also say VLookup(ItemtoFind, RangetoFind, ColumntoPickValueFrom, SortedorUnsorted) Example: A B […]

Welcome to MSOffice Gurus

Hi All, We are committed to share the knowledge that we have in the vastly used package, Microsoft Office.  The following posts will contain some extensive coverage of Tips from Word, Excel & PowerPoint and to some extent VBA. So, visit regularly to enhance your knowledge and drop in your comments. If you have any […]

« go back