Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel wont save changes to toolbar
I am using Excel 2000, Windows 2000....
Is it corrupt or is there a setting that somehow causes it not to save any changes I have made to my custom toolbar? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel wont save changes to toolbar
Excel saves your customized changes in a file named *.xlb (actual file and
location will vary with your version of excel and windows). If that file gets corrupted, it could cause trouble -- but I've never heard anyone complain that a corrupt *.xlb file would cause this problem. I'm guessing that you have multiple *.xlb files on your pc. And the real *.xlb is getting saved correctly -- but you have a *.xlb that overrides/supersedes your real one--and that one doesn't get updated. I had a *.xlb file in my XLStart folder. My real toolbar was loaded, then replaced with the *.xlb file in my XLStart folder. When I made changes, my real toolbar was updated, but that didn't help the next time I opened excel. (The file in my XLStart folder just kept superseding the real one!) So I'd start by closing excel and looking for all the *.xlb files. Windows|Start button|Search look for *.xlb in hidden folders and hidden files. You could move each *.xlb to a nice safe folder and restart excel. Then make a minor change to a toolbar. Close excel and search again for your *.xlb files. You'll see where the real file should be. Then it's your choice to take one of those saved files and put it in its rightful home--or just rebuild it from scratch. ====== On the other hand, your IT folks may have set up your pc so that you can't write to this location. (If you used to be able to save changes to the toolbar, then don't blame your IT folks.) Gary wrote: I am using Excel 2000, Windows 2000.... Is it corrupt or is there a setting that somehow causes it not to save any changes I have made to my custom toolbar? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel wont save changes to toolbar
That fixed it....
The xlb file was located in the C:\....\Excel\Xlstart directory which overrides any changes made to the xlb file located in the C:\...\Excel directory Thanks a bunch "Dave Peterson" wrote: Excel saves your customized changes in a file named *.xlb (actual file and location will vary with your version of excel and windows). If that file gets corrupted, it could cause trouble -- but I've never heard anyone complain that a corrupt *.xlb file would cause this problem. I'm guessing that you have multiple *.xlb files on your pc. And the real *.xlb is getting saved correctly -- but you have a *.xlb that overrides/supersedes your real one--and that one doesn't get updated. I had a *.xlb file in my XLStart folder. My real toolbar was loaded, then replaced with the *.xlb file in my XLStart folder. When I made changes, my real toolbar was updated, but that didn't help the next time I opened excel. (The file in my XLStart folder just kept superseding the real one!) So I'd start by closing excel and looking for all the *.xlb files. Windows|Start button|Search look for *.xlb in hidden folders and hidden files. You could move each *.xlb to a nice safe folder and restart excel. Then make a minor change to a toolbar. Close excel and search again for your *.xlb files. You'll see where the real file should be. Then it's your choice to take one of those saved files and put it in its rightful home--or just rebuild it from scratch. ====== On the other hand, your IT folks may have set up your pc so that you can't write to this location. (If you used to be able to save changes to the toolbar, then don't blame your IT folks.) Gary wrote: I am using Excel 2000, Windows 2000.... Is it corrupt or is there a setting that somehow causes it not to save any changes I have made to my custom toolbar? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel save as problem | Excel Discussion (Misc queries) | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
Excel 2002 crashing during "Save As" action. | Excel Discussion (Misc queries) |