Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 13th 05, 01:01 AM
MIKE MEDLIN
 
Posts: n/a
Default Saving Customized Toolbars in Excel 2003

I am hoping that someone can help me with a severe problem that l have been
having ever since i purchased the latest version of MS Office 2003. Every
time I re-boot my laptop, l must re-customize my Toolbars in Excel with
Office 2003. Always in the past with previous versions of Excel I have been
able to get the software to save my customized Toolbars, and Office 2003 does
save my settings in Word -- it is only in Excel that l have this recurring
nightmare.

l have sent repeated emails to MicroSoft for help, but they never respond.
l have sent this request to several chat boards for MS problems,...again with
no response.

please send me info on correcting this aggravating problem to:



  #3   Report Post  
Old January 13th 05, 01:47 AM
Gord Dibben
 
Posts: n/a
Default

Mike

The customizations are saved in Excel11.XLB file.

Mine is located in......

E:\Documents and Settings\Gord\Application Data\Microsoft\Excel

That file is not saving when you close Excel.

Do a file search. You may have more than one .XLB file.

If you find more than one, note where they are then make some changes to a
Toolbar and close Excel.

Which one changes?

Also, depending upon permissions, you may not be able to save to the folder
your *.XLB file is residing and Excel makes a new one because it can't/won't
access that file.


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 16:01:03 -0800, "MIKE MEDLIN"
wrote:

I am hoping that someone can help me with a severe problem that l have been
having ever since i purchased the latest version of MS Office 2003. Every
time I re-boot my laptop, l must re-customize my Toolbars in Excel with
Office 2003. Always in the past with previous versions of Excel I have been
able to get the software to save my customized Toolbars, and Office 2003 does
save my settings in Word -- it is only in Excel that l have this recurring
nightmare.

l have sent repeated emails to MicroSoft for help, but they never respond.
l have sent this request to several chat boards for MS problems,...again with
no response.

please send me info on correcting this aggravating problem to:



  #4   Report Post  
Old January 13th 05, 02:57 AM
MIKE MEDLIN
 
Posts: n/a
Default

Thanks for the quick reply, Nick,...much appreciated!

MM


"Nick Hodge" wrote:

Mike

Search for a file, or in your case probably files with an xlb extension, (so
search for *.xlb (it may be hidden)).

Delete what you find and restart Excel. Customise away and you should then
be OK. If not post back as it may be you need to redirect the registry if
it doesn't know where it should look.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"MIKE MEDLIN" wrote in message
...
I am hoping that someone can help me with a severe problem that l have been
having ever since i purchased the latest version of MS Office 2003. Every
time I re-boot my laptop, l must re-customize my Toolbars in Excel with
Office 2003. Always in the past with previous versions of Excel I have
been
able to get the software to save my customized Toolbars, and Office 2003
does
save my settings in Word -- it is only in Excel that l have this recurring
nightmare.

l have sent repeated emails to MicroSoft for help, but they never respond.
l have sent this request to several chat boards for MS problems,...again
with
no response.

please send me info on correcting this aggravating problem to:





  #5   Report Post  
Old January 13th 05, 02:59 AM
Dave Peterson
 
Posts: n/a
Default

In response to a private message:

First thing I would do is.

Close excel
windows start button|Search for *.xlb
(search through hidden folders for hidden files--just in case)

If you find any, move them to a different location (or delete them).

Then start up excel.

Make a small change to a toolbar (or create a new one).

Close excel and restart just to test.

If it worked, make some real changes.

When you're done making changes, close excel and find that *.xlb you just
created (by modifying the toolbars) using Windows start button|search.

Back it up to a nice spot.

If anything goes wrong, just copy the backup into the real location.

(my guess (and it's just a guess), is you have multiple versions of *.xlb and
your customizations are being overwritten with one that doesn't belong there
anymore. Placing a *.xlb in your XLStart will cause this.)

Another problem is that you may not authority to save to that folder. Windows
XP (I've heard) can be configured that way. I don't use windows XP, so I'm not
much help there.

In the future, you may want to post to the MS excel communities (available
somewhere at www.microsoft.com (easy to find if you look).

Or post through google's groups.

Or even connect directly to the MSServers and post to the newsgroups directly.

And to find answers to questions (this is not that uncommon), you could search
google's groups.

groups.google.com
(I'd click on the advanced button and tell google to search through the *excel*
newsgroups.)

--
Dave Peterson



hmmmmmmmmm.

MIKE MEDLIN wrote:

I am hoping that someone can help me with a severe problem that l have been
having ever since i purchased the latest version of MS Office 2003. Every
time I re-boot my laptop, l must re-customize my Toolbars in Excel with
Office 2003. Always in the past with previous versions of Excel I have been
able to get the software to save my customized Toolbars, and Office 2003 does
save my settings in Word -- it is only in Excel that l have this recurring
nightmare.

l have sent repeated emails to MicroSoft for help, but they never respond.
l have sent this request to several chat boards for MS problems,...again with
no response.

please send me info on correcting this aggravating problem to:



--

Dave Peterson


  #6   Report Post  
Old January 13th 05, 03:03 AM
MIKE MEDLIN
 
Posts: n/a
Default

thanks, Gord,...that worked!
Much appreciated!

MM

"Gord Dibben" wrote:

Mike

The customizations are saved in Excel11.XLB file.

Mine is located in......

E:\Documents and Settings\Gord\Application Data\Microsoft\Excel

That file is not saving when you close Excel.

Do a file search. You may have more than one .XLB file.

If you find more than one, note where they are then make some changes to a
Toolbar and close Excel.

Which one changes?

Also, depending upon permissions, you may not be able to save to the folder
your *.XLB file is residing and Excel makes a new one because it can't/won't
access that file.


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 16:01:03 -0800, "MIKE MEDLIN"
wrote:

I am hoping that someone can help me with a severe problem that l have been
having ever since i purchased the latest version of MS Office 2003. Every
time I re-boot my laptop, l must re-customize my Toolbars in Excel with
Office 2003. Always in the past with previous versions of Excel I have been
able to get the software to save my customized Toolbars, and Office 2003 does
save my settings in Word -- it is only in Excel that l have this recurring
nightmare.

l have sent repeated emails to MicroSoft for help, but they never respond.
l have sent this request to several chat boards for MS problems,...again with
no response.

please send me info on correcting this aggravating problem to:






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM
Excel 2003 Customized Menu Bar Fernando Gomez Excel Discussion (Misc queries) 2 December 16th 04 11:28 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 14th 04 12:51 AM
Opening and saving Excel 2003 file from Excel 97. Rodrigo Excel Discussion (Misc queries) 2 December 12th 04 03:17 PM
Getting Excel 2003 to save Custom Toolbars MIKE MEDLIN Excel Discussion (Misc queries) 1 December 7th 04 08:33 PM


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017