Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel
QBob
 
Posts: n/a
Default Excel Toolbar does not save

I have an excel toolbar that will not save (or is being overwritten after
saving). I modify the toolbar with my icons and then close excel. When I
reopenExcel, the toolbar displays like I saved it for about 2 seconds then
reverts back to its original format. I have deleted the excel.xlb file,
recreated it, renamed it, etc... I have saved the document, saved a
template and removed adobe. Only to have the toolbars revert back to their
original state.. I have even reinstalled Excel. All other toolbars work
like normal (Word, PP, Outlook), just not Excel. Any ideas greatly
appreciated. Currently my workaround is to create a template (XLB file) and
open Excel from that everytime, but if anyone just opens Excel any other way
other than using the template icon, it uses the xlb that takes it back to
defaults. Thanks!


  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel
Dave Peterson
 
Posts: n/a
Default Excel Toolbar does not save

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.


QBob wrote:

I have an excel toolbar that will not save (or is being overwritten after
saving). I modify the toolbar with my icons and then close excel. When I
reopenExcel, the toolbar displays like I saved it for about 2 seconds then
reverts back to its original format. I have deleted the excel.xlb file,
recreated it, renamed it, etc... I have saved the document, saved a
template and removed adobe. Only to have the toolbars revert back to their
original state.. I have even reinstalled Excel. All other toolbars work
like normal (Word, PP, Outlook), just not Excel. Any ideas greatly
appreciated. Currently my workaround is to create a template (XLB file) and
open Excel from that everytime, but if anyone just opens Excel any other way
other than using the template icon, it uses the xlb that takes it back to
defaults. Thanks!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel
QBob
 
Posts: n/a
Default Excel Toolbar does not save

Thanks for the post. I tried this and still no luck. I deleted every xlb
file I could find, let the system generate a new one, found that location,
changed the toolbar, saved it and even modified one and put it in that
folder, however each time it is overwritten by the generic one. It appears
as if something is overriding it, like another application, because it
appears with my configuration for about 1-3 seconds and then reverts.
Thanks again for the post, any more ideas.


"Dave Peterson" wrote in message
...
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.


QBob wrote:

I have an excel toolbar that will not save (or is being overwritten after
saving). I modify the toolbar with my icons and then close excel. When
I
reopenExcel, the toolbar displays like I saved it for about 2 seconds
then
reverts back to its original format. I have deleted the excel.xlb file,
recreated it, renamed it, etc... I have saved the document, saved a
template and removed adobe. Only to have the toolbars revert back to
their
original state.. I have even reinstalled Excel. All other toolbars work
like normal (Word, PP, Outlook), just not Excel. Any ideas greatly
appreciated. Currently my workaround is to create a template (XLB file)
and
open Excel from that everytime, but if anyone just opens Excel any other
way
other than using the template icon, it uses the xlb that takes it back to
defaults. Thanks!


--

Dave Peterson



  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel
Dave Peterson
 
Posts: n/a
Default Excel Toolbar does not save

I'm guessing you missed one (a common problem).

close excel
shell to DOS
windows start button|Run
cmd (windows 2k/xp)
command (windows 98)

At the DOS prompt:
C: (to get to the C: drive)
cd\ (to get to the root directory)

dir *.xlb /s

the /s means to search through subdirectories.

Maybe you'll be able to see/delete the files.

QBob wrote:

Thanks for the post. I tried this and still no luck. I deleted every xlb
file I could find, let the system generate a new one, found that location,
changed the toolbar, saved it and even modified one and put it in that
folder, however each time it is overwritten by the generic one. It appears
as if something is overriding it, like another application, because it
appears with my configuration for about 1-3 seconds and then reverts.
Thanks again for the post, any more ideas.

"Dave Peterson" wrote in message
...
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.


QBob wrote:

I have an excel toolbar that will not save (or is being overwritten after
saving). I modify the toolbar with my icons and then close excel. When
I
reopenExcel, the toolbar displays like I saved it for about 2 seconds
then
reverts back to its original format. I have deleted the excel.xlb file,
recreated it, renamed it, etc... I have saved the document, saved a
template and removed adobe. Only to have the toolbars revert back to
their
original state.. I have even reinstalled Excel. All other toolbars work
like normal (Word, PP, Outlook), just not Excel. Any ideas greatly
appreciated. Currently my workaround is to create a template (XLB file)
and
open Excel from that everytime, but if anyone just opens Excel any other
way
other than using the template icon, it uses the xlb that takes it back to
defaults. Thanks!


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel
 
Posts: n/a
Default Excel Toolbar does not save

who cares about excel; google has come to the rescue

http://news.com.com/Google+Spreadshe...l?tag=nefd.top




Dave Peterson wrote:
I'm guessing you missed one (a common problem).

close excel
shell to DOS
windows start button|Run
cmd (windows 2k/xp)
command (windows 98)

At the DOS prompt:
C: (to get to the C: drive)
cd\ (to get to the root directory)

dir *.xlb /s

the /s means to search through subdirectories.

Maybe you'll be able to see/delete the files.

QBob wrote:

Thanks for the post. I tried this and still no luck. I deleted every xlb
file I could find, let the system generate a new one, found that location,
changed the toolbar, saved it and even modified one and put it in that
folder, however each time it is overwritten by the generic one. It appears
as if something is overriding it, like another application, because it
appears with my configuration for about 1-3 seconds and then reverts.
Thanks again for the post, any more ideas.

"Dave Peterson" wrote in message
...
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.


QBob wrote:

I have an excel toolbar that will not save (or is being overwritten after
saving). I modify the toolbar with my icons and then close excel. When
I
reopenExcel, the toolbar displays like I saved it for about 2 seconds
then
reverts back to its original format. I have deleted the excel.xlb file,
recreated it, renamed it, etc... I have saved the document, saved a
template and removed adobe. Only to have the toolbars revert back to
their
original state.. I have even reinstalled Excel. All other toolbars work
like normal (Word, PP, Outlook), just not Excel. Any ideas greatly
appreciated. Currently my workaround is to create a template (XLB file)
and
open Excel from that everytime, but if anyone just opens Excel any other
way
other than using the template icon, it uses the xlb that takes it back to
defaults. Thanks!

--

Dave Peterson


--

Dave Peterson


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) 2 May 13th 23 11:46 AM
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
Excel save as problem Gabor Excel Discussion (Misc queries) 3 February 23rd 06 04:35 PM
Excel XP: File name in Title Bar not changed after Save As... Dominic Excel Discussion (Misc queries) 9 August 1st 05 12:58 PM
Excel 2002 crashing during "Save As" action. Andy T Excel Discussion (Misc queries) 1 January 4th 05 11:34 PM


All times are GMT +1. The time now is 06:21 AM.

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

About Us

"It's about Microsoft Excel"