Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2007
    Location
    California, USA
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    right click mouse format function gone (MS Office xp1)

    The mouse right click format stopped working in Excel but works in the other Office programs. Excel options shows everything Ok. I have checked and double checked everything with no sucess. Any suggestions would be appreciated.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: right click mouse format function gone (MS Office xp1)

    Hi Bill

    1) Shut down Excel
    2) Double click My Computer
    3) Locate the Excel.xlb file in the following folder: Cocuments and Settings[username]Application DataMicrosoftExcel *
    4) Right click, select "Rename," type "ExcelXLB.old" (without the quotes), and then press ENTER
    5) Restart Excel


    * If Excel.xlb is not in this folder, search for it from the Start menu and continue to #4 above
    Jerry

  3. #3
    Star Lounger
    Join Date
    May 2007
    Location
    California, USA
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: right click mouse format function gone (MS Office xp1)

    Hi Jerry, thanks for the reply. I did the search first in My Documents and then on the hard drive and was unable to locate a file by that name. Do you think the file name was changed in the 2007 version of Excel?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: right click mouse format function gone (MS Office xp1)

    The file is probably named Excel12.xlb (12 being the internal version number for Office 2007) and stored in the folder Cocuments and Settings<username>Application DataMicrosoftExcel. Since Application Data is a hidden folder, you must show hidden files and folders in order to see it.

  5. #5
    Star Lounger
    Join Date
    May 2007
    Location
    California, USA
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: right click mouse format function gone (MS Office xp1)

    Thank you Jerry and Hans. That fixed the problem. You guys are awesome!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •