Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Excel 2003 won't save customized changes

I am trying to get Excel 2003 to save any changes I make to my toolbars, like
add different buttons and such, but they go away whenever I restart Excel.
It just started happening. I checked and it seems like the XLB file is
getting update. I even deleted the XLB file and let it recreate only to
still have the same problem. Any ideas? Thanks.



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 won't save customized changes

Do you have multiple *.xlb files--maybe one in XLStart where it doesn't belong.

It could be that you have a second file opening after the first one opens (with
the correct toolbars).

The second *.xlb file supersedes the first.



Joe wrote:

I am trying to get Excel 2003 to save any changes I make to my toolbars, like
add different buttons and such, but they go away whenever I restart Excel.
It just started happening. I checked and it seems like the XLB file is
getting update. I even deleted the XLB file and let it recreate only to
still have the same problem. Any ideas? Thanks.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Excel 2003 won't save customized changes

I verified that there is only one .xlb file. I have tried deleting it and
letting Excel recreate. Still won't work. I can move the toolbars around
and it will keep that setting, but when I drag a button to add to a toolbar
(like Fill Down, or Fill Right), the button appears, then doesn't come back
when I close Excel and come back in.

"Dave Peterson" wrote:

Do you have multiple *.xlb files--maybe one in XLStart where it doesn't belong.

It could be that you have a second file opening after the first one opens (with
the correct toolbars).

The second *.xlb file supersedes the first.



Joe wrote:

I am trying to get Excel 2003 to save any changes I make to my toolbars, like
add different buttons and such, but they go away whenever I restart Excel.
It just started happening. I checked and it seems like the XLB file is
getting update. I even deleted the XLB file and let it recreate only to
still have the same problem. Any ideas? Thanks.


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 won't save customized changes

Sometimes those *.xlb files can be difficult to find.

I'd try this:

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/rename the files.



Joe wrote:

I verified that there is only one .xlb file. I have tried deleting it and
letting Excel recreate. Still won't work. I can move the toolbars around
and it will keep that setting, but when I drag a button to add to a toolbar
(like Fill Down, or Fill Right), the button appears, then doesn't come back
when I close Excel and come back in.

"Dave Peterson" wrote:

Do you have multiple *.xlb files--maybe one in XLStart where it doesn't belong.

It could be that you have a second file opening after the first one opens (with
the correct toolbars).

The second *.xlb file supersedes the first.



Joe wrote:

I am trying to get Excel 2003 to save any changes I make to my toolbars, like
add different buttons and such, but they go away whenever I restart Excel.
It just started happening. I checked and it seems like the XLB file is
getting update. I even deleted the XLB file and let it recreate only to
still have the same problem. Any ideas? Thanks.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Excel 2003 won't save customized changes

I tried that and it still only comes up with the one file that it finds. Any
other ideas?

"Dave Peterson" wrote:

Sometimes those *.xlb files can be difficult to find.

I'd try this:

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/rename the files.



Joe wrote:

I verified that there is only one .xlb file. I have tried deleting it and
letting Excel recreate. Still won't work. I can move the toolbars around
and it will keep that setting, but when I drag a button to add to a toolbar
(like Fill Down, or Fill Right), the button appears, then doesn't come back
when I close Excel and come back in.

"Dave Peterson" wrote:

Do you have multiple *.xlb files--maybe one in XLStart where it doesn't belong.

It could be that you have a second file opening after the first one opens (with
the correct toolbars).

The second *.xlb file supersedes the first.



Joe wrote:

I am trying to get Excel 2003 to save any changes I make to my toolbars, like
add different buttons and such, but they go away whenever I restart Excel.
It just started happening. I checked and it seems like the XLB file is
getting update. I even deleted the XLB file and let it recreate only to
still have the same problem. Any ideas? Thanks.

--

Dave Peterson


--

Dave Peterson



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 won't save customized changes

Nope. Sorry.

Joe wrote:

I tried that and it still only comes up with the one file that it finds. Any
other ideas?

"Dave Peterson" wrote:

Sometimes those *.xlb files can be difficult to find.

I'd try this:

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/rename the files.



Joe wrote:

I verified that there is only one .xlb file. I have tried deleting it and
letting Excel recreate. Still won't work. I can move the toolbars around
and it will keep that setting, but when I drag a button to add to a toolbar
(like Fill Down, or Fill Right), the button appears, then doesn't come back
when I close Excel and come back in.

"Dave Peterson" wrote:

Do you have multiple *.xlb files--maybe one in XLStart where it doesn't belong.

It could be that you have a second file opening after the first one opens (with
the correct toolbars).

The second *.xlb file supersedes the first.



Joe wrote:

I am trying to get Excel 2003 to save any changes I make to my toolbars, like
add different buttons and such, but they go away whenever I restart Excel.
It just started happening. I checked and it seems like the XLB file is
getting update. I even deleted the XLB file and let it recreate only to
still have the same problem. Any ideas? Thanks.

--

Dave Peterson


--

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
CANT SAVE TOOLBAR CHANGES EXCEL 2003) Paul628 Excel Discussion (Misc queries) 2 November 8th 05 07:48 PM
Excel 2003 doesn't prompt to save on exit? Alan Cannon Setting up and Configuration of Excel 1 October 23rd 05 11:02 PM
Excell VS Office Cathyandrea Excel Discussion (Misc queries) 1 September 19th 05 07:02 AM
Excel 2003, cannot save a spreadsheet.xls remleys_west Excel Discussion (Misc queries) 0 April 5th 05 06:11 PM


All times are GMT +1. The time now is 06:23 PM.

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"