Tuesday, February 8, 2011

Unable to delete rows on Excel, option is grey out

If you are unable to delete rows or change the format because the option is disabled, looks like one macro or one update changed the configuration profile file of the Excel.
To fix this problem follow the next steps:

  1. Got to C:\Users\%UserProfile%\AppData\Roaming in Windows 7 or to  C:\Documents and Settings\%UserProfile%\Application Data in Windows XP
  2. Locate the file Excel12.xlb and rename it
  3. By deleting or renaming this file Excel will create a new one
  4. Run again Excel and the options should be there

7 comments: