To fix this problem follow the next steps:
- Got to C:\Users\%UserProfile%\AppData\Roaming in Windows 7 or to C:\Documents and Settings\%UserProfile%\Application Data in Windows XP
- Locate the file Excel12.xlb and rename it
- By deleting or renaming this file Excel will create a new one
- Run again Excel and the options should be there
Worked like charm ...thanks
ReplyDeleteIt's really work.Thanks a lot for this true post. - kartick
ReplyDeletethANK YOU BORTHER!!!
ReplyDeleteIt worked, only that I have to rename Excel15.xlb (Renaming Excel12.xlb did not work!)
ReplyDeleteIt worked Thanks a lot
ReplyDeletemany thanks, it works in 2021 as well.
ReplyDeletethanks. works in Feb 2021
ReplyDelete