Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Which file stores my Toolbar settings? (excel 2003)

    I have Excel at work and would like my toolbars at home to look like the ones at work. Which file stores my Toolbar settings? Where can I find this file?

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

    Re: Which file stores my Toolbar settings? (excel 2003)

    It's in a file with extension .xlb (usually Excel11.xlb for Excel 2003).
    Under Windows XP it is stored in Cocuments and Settings<username>Application DataMicrosoftExcel.
    Under Windows Vista it depends on whether you have a roaming profile, I think.

    Note: Application Data is a hidden folder, so you must show hidden files and folders in Windows Explorer in order to see it. You can set this in the View tab of Tools | Folder Options in Windows Explorer.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Which file stores my Toolbar settings? (excel 2003)

    Aside from toolbar data, what does Excel use this file for?

    Not that I'm complaining, but my xlb file (it's got today's date) is 11mb.

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

    Re: Which file stores my Toolbar settings? (excel 2003)

    That's quite big! (I have extensively customized my toolbars and the xlb file is 63 KB...)
    Apart from toolbar customizations, it also contains custom lists (from the Custom Lists tab in Tools | Options) as far as I know.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Which file stores my Toolbar settings? (excel 2003)

    I suppose that I can make a copy of the file in a another folder, then exit Excel, delete the *.xlb, restart Excel and see what happens.

    Do you see any risks or traps in that? If it doesn't work or I'm missing something, then I should just be able to copy the file back to its original location and restart Excel.

    Now that I think about it, how about *.xla's? Is this where Add-Ins are stored? I'm using ASAP, FindLink and JWalk's Chart Tools.

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

    Re: Which file stores my Toolbar settings? (excel 2003)

    I'd quit Excel and move the file to another folder, then restart Excel.
    You can move the file back later (while Excel isn't active). If it doesn't "take", you can force Excel to do so by opening the .xlb file.

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

    Re: Which file stores my Toolbar settings? (excel 2003)

    Files with extension .xla are Excel add-ins. Many of them create their own toolbar(s) when loaded, and delete them again when unloaded.

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Which file stores my Toolbar settings? (excel 2003)

    Thanks Hans. I see your point.

    One add-in, ASAP adds its own menu with 300 +/- commands.

    So I could uncheck all of my checked Add-Ins, exit Excel, and recheck the size of the xlb and it should be substantially smaller.

    Many thanks.

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

    Re: Which file stores my Toolbar settings? (excel 2003)

    I doubt it - the custom toolbars from those add-ins aren't stored in your .xlb file, as far as I know. But you could try it, of course.

Posting Permissions

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