A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel toolbar customization



 
 
Thread Tools Display Modes
  #11  
Old July 25th, 2008, 04:20 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Excel toolbar customization

Except for looking again, I'm out of suggestions.

Griffinspc wrote:

OK, tried both Gord's and Dave's last suggestions. No luck with either. It
seems weirder and weirder. I found one other XLSTART folder but it was empty
and I'm obviously stumped.

"Dave Peterson" wrote:

Reinstalling excel won't help.

*.xlb is one of the files that excel knows not to destroy when you
uninstall/reinstall.

I'm betting that you still haven't found all of them yet.

Search again and delete the ones you find.

But then use windows search for a folder named XLStart (depending on your
upgrade path, you may have multiple XLStart folders, too!).

Then open those folders to see if you have *.xlb files in any of those.

Griffinspc wrote:

Only one found in the command line search in the same location. I deleted it
again and made a few changes to the toolbar, closed excel. checked the xlb
file and the toolbar shows my changes. Closed it and opened Excel and no
changes. It seemed logical that there was a 2nd xbl file but no luck. So
where is my Excel pointing?

Would it do me any good to uninstall Excel and reinstall or is this a
registry issue so the new install will be looking at the same file? I've had
to delete the normal.dot file before in Word and had noting like this happen.

"Dave Peterson" wrote:

You haven't found all of them yet.

Maybe this will help:

Close excel

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files and then delete those files.

Then try modifying your toolbar again, close excel and reopen to see if the
changes are still there.

Griffinspc wrote:

I have modified my Excel toolbars many times with no problem however on this
new machine at work with Office 2003 and all service packs, etc., the changes
I make are not retained when i close and open Excel. I've tried the Detect &
Repair and looked for any Office updates and all are current. Help.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #12  
Old July 26th, 2008, 12:37 AM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel toolbar customization

Likewise for me.

You cannot run Excel without an *.xlb file


Gord

On Fri, 25 Jul 2008 10:20:17 -0500, Dave Peterson
wrote:

Except for looking again, I'm out of suggestions.

Griffinspc wrote:

OK, tried both Gord's and Dave's last suggestions. No luck with either. It
seems weirder and weirder. I found one other XLSTART folder but it was empty
and I'm obviously stumped.

"Dave Peterson" wrote:

Reinstalling excel won't help.

*.xlb is one of the files that excel knows not to destroy when you
uninstall/reinstall.

I'm betting that you still haven't found all of them yet.

Search again and delete the ones you find.

But then use windows search for a folder named XLStart (depending on your
upgrade path, you may have multiple XLStart folders, too!).

Then open those folders to see if you have *.xlb files in any of those.

Griffinspc wrote:

Only one found in the command line search in the same location. I deleted it
again and made a few changes to the toolbar, closed excel. checked the xlb
file and the toolbar shows my changes. Closed it and opened Excel and no
changes. It seemed logical that there was a 2nd xbl file but no luck. So
where is my Excel pointing?

Would it do me any good to uninstall Excel and reinstall or is this a
registry issue so the new install will be looking at the same file? I've had
to delete the normal.dot file before in Word and had noting like this happen.

"Dave Peterson" wrote:

You haven't found all of them yet.

Maybe this will help:

Close excel

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files and then delete those files.

Then try modifying your toolbar again, close excel and reopen to see if the
changes are still there.

Griffinspc wrote:

I have modified my Excel toolbars many times with no problem however on this
new machine at work with Office 2003 and all service packs, etc., the changes
I make are not retained when i close and open Excel. I've tried the Detect &
Repair and looked for any Office updates and all are current. Help.

--

Dave Peterson


--

Dave Peterson


  #13  
Old July 26th, 2008, 03:34 AM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Excel toolbar customization

Just to add...

I closed excel, deleted my *.xlb and restarted excel. Excel started ok.

But when I closed excel, that *.xlb file got created--and I didn't modify any
toolbar.

======
To the OP.

Try looking this way:
Close excel
Windows start button|Run
type this and hit enter:
%appdata%

This should take you to something like:
C:\Documents and Settings\(username)\Application Data

Now open the Microsoft folder, then the Excel folder.
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel

Look for *.xlb (and delete any you find)

And then look in the XLStart folder.
Delete any *.xlb files you find there.

===========
If you have a *.xlb file in your xlstart folder, then you'll see the problem you
describe. The "real" toolbar is, er, should not be in the XLStart folder.

When excel starts, you'll see the "real" toolbar (if your eyes are good
enough!). But the *.xlb file in XLStart will be loaded automatically--and it'll
replace the "real" version.

Make changes and close excel. The *.xlb file that gets updated is the "real"
version. But the next time you open excel, you'll see the (not updated) version
from XLStart.



Gord Dibben wrote:

Likewise for me.

You cannot run Excel without an *.xlb file

Gord

On Fri, 25 Jul 2008 10:20:17 -0500, Dave Peterson
wrote:

Except for looking again, I'm out of suggestions.

Griffinspc wrote:

OK, tried both Gord's and Dave's last suggestions. No luck with either. It
seems weirder and weirder. I found one other XLSTART folder but it was empty
and I'm obviously stumped.

"Dave Peterson" wrote:

Reinstalling excel won't help.

*.xlb is one of the files that excel knows not to destroy when you
uninstall/reinstall.

I'm betting that you still haven't found all of them yet.

Search again and delete the ones you find.

But then use windows search for a folder named XLStart (depending on your
upgrade path, you may have multiple XLStart folders, too!).

Then open those folders to see if you have *.xlb files in any of those.

Griffinspc wrote:

Only one found in the command line search in the same location. I deleted it
again and made a few changes to the toolbar, closed excel. checked the xlb
file and the toolbar shows my changes. Closed it and opened Excel and no
changes. It seemed logical that there was a 2nd xbl file but no luck. So
where is my Excel pointing?

Would it do me any good to uninstall Excel and reinstall or is this a
registry issue so the new install will be looking at the same file? I've had
to delete the normal.dot file before in Word and had noting like this happen.

"Dave Peterson" wrote:

You haven't found all of them yet.

Maybe this will help:

Close excel

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files and then delete those files.

Then try modifying your toolbar again, close excel and reopen to see if the
changes are still there.

Griffinspc wrote:

I have modified my Excel toolbars many times with no problem however on this
new machine at work with Office 2003 and all service packs, etc., the changes
I make are not retained when i close and open Excel. I've tried the Detect &
Repair and looked for any Office updates and all are current. Help.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #14  
Old July 26th, 2008, 04:05 AM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel toolbar customization

That's what I meant.........Excel will re-create oneg


Gord

On Fri, 25 Jul 2008 21:34:55 -0500, Dave Peterson
wrote:

Just to add...

I closed excel, deleted my *.xlb and restarted excel. Excel started ok.

But when I closed excel, that *.xlb file got created--and I didn't modify any
toolbar.

======
To the OP.

Try looking this way:
Close excel
Windows start button|Run
type this and hit enter:
%appdata%

This should take you to something like:
C:\Documents and Settings\(username)\Application Data

Now open the Microsoft folder, then the Excel folder.
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel

Look for *.xlb (and delete any you find)

And then look in the XLStart folder.
Delete any *.xlb files you find there.

===========
If you have a *.xlb file in your xlstart folder, then you'll see the problem you
describe. The "real" toolbar is, er, should not be in the XLStart folder.

When excel starts, you'll see the "real" toolbar (if your eyes are good
enough!). But the *.xlb file in XLStart will be loaded automatically--and it'll
replace the "real" version.

Make changes and close excel. The *.xlb file that gets updated is the "real"
version. But the next time you open excel, you'll see the (not updated) version
from XLStart.



Gord Dibben wrote:

Likewise for me.

You cannot run Excel without an *.xlb file

Gord

On Fri, 25 Jul 2008 10:20:17 -0500, Dave Peterson
wrote:

Except for looking again, I'm out of suggestions.

Griffinspc wrote:

OK, tried both Gord's and Dave's last suggestions. No luck with either. It
seems weirder and weirder. I found one other XLSTART folder but it was empty
and I'm obviously stumped.

"Dave Peterson" wrote:

Reinstalling excel won't help.

*.xlb is one of the files that excel knows not to destroy when you
uninstall/reinstall.

I'm betting that you still haven't found all of them yet.

Search again and delete the ones you find.

But then use windows search for a folder named XLStart (depending on your
upgrade path, you may have multiple XLStart folders, too!).

Then open those folders to see if you have *.xlb files in any of those.

Griffinspc wrote:

Only one found in the command line search in the same location. I deleted it
again and made a few changes to the toolbar, closed excel. checked the xlb
file and the toolbar shows my changes. Closed it and opened Excel and no
changes. It seemed logical that there was a 2nd xbl file but no luck. So
where is my Excel pointing?

Would it do me any good to uninstall Excel and reinstall or is this a
registry issue so the new install will be looking at the same file? I've had
to delete the normal.dot file before in Word and had noting like this happen.

"Dave Peterson" wrote:

You haven't found all of them yet.

Maybe this will help:

Close excel

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files and then delete those files.

Then try modifying your toolbar again, close excel and reopen to see if the
changes are still there.

Griffinspc wrote:

I have modified my Excel toolbars many times with no problem however on this
new machine at work with Office 2003 and all service packs, etc., the changes
I make are not retained when i close and open Excel. I've tried the Detect &
Repair and looked for any Office updates and all are current. Help.

--

Dave Peterson


--

Dave Peterson


  #15  
Old July 28th, 2008, 08:49 PM posted to microsoft.public.excel.setup
Griffinspc
external usenet poster
 
Posts: 6
Default Excel toolbar customization

OK, wanted to let you guys know I fixed it and how. Having tried all the
suggesteions you made which I appreciated, I finally did uninstall Excel and
re-installed it. That in itself seemed to be a failure but one last time I
also did a detect and repair immediately after the install and told it to
reset everythig to default and not to recreate shortcuts. I had done this
before but not after a reinstall. This time it worked. My cutomized toolbars
are sticking. What a pain this was.

"Gord Dibben" wrote:

That's what I meant.........Excel will re-create oneg


Gord

On Fri, 25 Jul 2008 21:34:55 -0500, Dave Peterson
wrote:

Just to add...

I closed excel, deleted my *.xlb and restarted excel. Excel started ok.

But when I closed excel, that *.xlb file got created--and I didn't modify any
toolbar.

======
To the OP.

Try looking this way:
Close excel
Windows start button|Run
type this and hit enter:
%appdata%

This should take you to something like:
C:\Documents and Settings\(username)\Application Data

Now open the Microsoft folder, then the Excel folder.
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel

Look for *.xlb (and delete any you find)

And then look in the XLStart folder.
Delete any *.xlb files you find there.

===========
If you have a *.xlb file in your xlstart folder, then you'll see the problem you
describe. The "real" toolbar is, er, should not be in the XLStart folder.

When excel starts, you'll see the "real" toolbar (if your eyes are good
enough!). But the *.xlb file in XLStart will be loaded automatically--and it'll
replace the "real" version.

Make changes and close excel. The *.xlb file that gets updated is the "real"
version. But the next time you open excel, you'll see the (not updated) version
from XLStart.



Gord Dibben wrote:

Likewise for me.

You cannot run Excel without an *.xlb file

Gord

On Fri, 25 Jul 2008 10:20:17 -0500, Dave Peterson
wrote:

Except for looking again, I'm out of suggestions.

Griffinspc wrote:

OK, tried both Gord's and Dave's last suggestions. No luck with either. It
seems weirder and weirder. I found one other XLSTART folder but it was empty
and I'm obviously stumped.

"Dave Peterson" wrote:

Reinstalling excel won't help.

*.xlb is one of the files that excel knows not to destroy when you
uninstall/reinstall.

I'm betting that you still haven't found all of them yet.

Search again and delete the ones you find.

But then use windows search for a folder named XLStart (depending on your
upgrade path, you may have multiple XLStart folders, too!).

Then open those folders to see if you have *.xlb files in any of those.

Griffinspc wrote:

Only one found in the command line search in the same location. I deleted it
again and made a few changes to the toolbar, closed excel. checked the xlb
file and the toolbar shows my changes. Closed it and opened Excel and no
changes. It seemed logical that there was a 2nd xbl file but no luck. So
where is my Excel pointing?

Would it do me any good to uninstall Excel and reinstall or is this a
registry issue so the new install will be looking at the same file? I've had
to delete the normal.dot file before in Word and had noting like this happen.

"Dave Peterson" wrote:

You haven't found all of them yet.

Maybe this will help:

Close excel

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files and then delete those files.

Then try modifying your toolbar again, close excel and reopen to see if the
changes are still there.

Griffinspc wrote:

I have modified my Excel toolbars many times with no problem however on this
new machine at work with Office 2003 and all service packs, etc., the changes
I make are not retained when i close and open Excel. I've tried the Detect &
Repair and looked for any Office updates and all are current. Help.

--

Dave Peterson


--

Dave Peterson



  #16  
Old July 29th, 2008, 06:07 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Excel toolbar customization

Thanks for the posting your particular solution.

Too bad you had to go through all that.


Gord

On Mon, 28 Jul 2008 12:49:15 -0700, Griffinspc
wrote:

OK, wanted to let you guys know I fixed it and how. Having tried all the
suggesteions you made which I appreciated, I finally did uninstall Excel and
re-installed it. That in itself seemed to be a failure but one last time I
also did a detect and repair immediately after the install and told it to
reset everythig to default and not to recreate shortcuts. I had done this
before but not after a reinstall. This time it worked. My cutomized toolbars
are sticking. What a pain this was.

"Gord Dibben" wrote:

That's what I meant.........Excel will re-create oneg


Gord

On Fri, 25 Jul 2008 21:34:55 -0500, Dave Peterson
wrote:

Just to add...

I closed excel, deleted my *.xlb and restarted excel. Excel started ok.

But when I closed excel, that *.xlb file got created--and I didn't modify any
toolbar.

======
To the OP.

Try looking this way:
Close excel
Windows start button|Run
type this and hit enter:
%appdata%

This should take you to something like:
C:\Documents and Settings\(username)\Application Data

Now open the Microsoft folder, then the Excel folder.
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel

Look for *.xlb (and delete any you find)

And then look in the XLStart folder.
Delete any *.xlb files you find there.

===========
If you have a *.xlb file in your xlstart folder, then you'll see the problem you
describe. The "real" toolbar is, er, should not be in the XLStart folder.

When excel starts, you'll see the "real" toolbar (if your eyes are good
enough!). But the *.xlb file in XLStart will be loaded automatically--and it'll
replace the "real" version.

Make changes and close excel. The *.xlb file that gets updated is the "real"
version. But the next time you open excel, you'll see the (not updated) version
from XLStart.



Gord Dibben wrote:

Likewise for me.

You cannot run Excel without an *.xlb file

Gord

On Fri, 25 Jul 2008 10:20:17 -0500, Dave Peterson
wrote:

Except for looking again, I'm out of suggestions.

Griffinspc wrote:

OK, tried both Gord's and Dave's last suggestions. No luck with either. It
seems weirder and weirder. I found one other XLSTART folder but it was empty
and I'm obviously stumped.

"Dave Peterson" wrote:

Reinstalling excel won't help.

*.xlb is one of the files that excel knows not to destroy when you
uninstall/reinstall.

I'm betting that you still haven't found all of them yet.

Search again and delete the ones you find.

But then use windows search for a folder named XLStart (depending on your
upgrade path, you may have multiple XLStart folders, too!).

Then open those folders to see if you have *.xlb files in any of those.

Griffinspc wrote:

Only one found in the command line search in the same location. I deleted it
again and made a few changes to the toolbar, closed excel. checked the xlb
file and the toolbar shows my changes. Closed it and opened Excel and no
changes. It seemed logical that there was a 2nd xbl file but no luck. So
where is my Excel pointing?

Would it do me any good to uninstall Excel and reinstall or is this a
registry issue so the new install will be looking at the same file? I've had
to delete the normal.dot file before in Word and had noting like this happen.

"Dave Peterson" wrote:

You haven't found all of them yet.

Maybe this will help:

Close excel

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files and then delete those files.

Then try modifying your toolbar again, close excel and reopen to see if the
changes are still there.

Griffinspc wrote:

I have modified my Excel toolbars many times with no problem however on this
new machine at work with Office 2003 and all service packs, etc., the changes
I make are not retained when i close and open Excel. I've tried the Detect &
Repair and looked for any Office updates and all are current. Help.

--

Dave Peterson


--

Dave Peterson




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:12 PM.


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