If all the above solution doesn't work then the Extreme solution to get the excel back to the default setting... Go to the registry editor..!
Code:
HKEY_CURRENT_USER\Software\Microsoft\Office\[version]
Go to the above position in which "[version]" represents your Office version number (e.g., "9.0" for Office 2000). The [version]\ key should contain a key under named "Excel", with a subkey under that, named "Options". With Excel NOT running, you can either:
- Look weather the string value of 'Options' key is showing for nay errors. If it shows any of the error then :
- Delete that key to make it again default.
Bookmarks