Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can not do Add-Ins in Excel

When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Can not do Add-Ins in Excel

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Can not do Add-Ins in Excel

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Can not do Add-Ins in Excel

Joseph

You "will" have an *.xlb file.

Also in Folder OptionsView uncheck "hide extensions for known file types"


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 07:47:00 -0800, Joseph A. Carter
wrote:

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Can not do Add-Ins in Excel

Okay, found and got rid of Excel11.xlb. Still no luck (add-ins don't work).

Excel did not create a new xlb file even after rebooting the computer.


"Gord Dibben" wrote:

Joseph

You "will" have an *.xlb file.

Also in Folder OptionsView uncheck "hide extensions for known file types"


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 07:47:00 -0800, Joseph A. Carter
wrote:

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Can not do Add-Ins in Excel

Hi Joseph

Look in the HelpAbout Microsoft Excel menu and see if you have a disabled
add-in
in Disabled items


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" wrote in
message ...
Okay, found and got rid of Excel11.xlb. Still no luck (add-ins don't
work).

Excel did not create a new xlb file even after rebooting the computer.


"Gord Dibben" wrote:

Joseph

You "will" have an *.xlb file.

Also in Folder OptionsView uncheck "hide extensions for known file
types"


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 07:47:00 -0800, Joseph A. Carter
wrote:

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is
< 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and
folders)
3. Rename or delete the .xlb file or files (In 2002 the name =
Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote
in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003),
Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to
close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office
Excel."

Any information would be much appreciated.

Thanks,

Joe





  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Can not do Add-Ins in Excel

If you make a change (however trivial), you'll recreate the *.xlb file.

(I don't have a guess about the real problem, though.)

Did you try Help|detect and repair? Or maybe reinstalling?




Joseph A. Carter wrote:

Okay, found and got rid of Excel11.xlb. Still no luck (add-ins don't work).

Excel did not create a new xlb file even after rebooting the computer.

"Gord Dibben" wrote:

Joseph

You "will" have an *.xlb file.

Also in Folder OptionsView uncheck "hide extensions for known file types"


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 07:47:00 -0800, Joseph A. Carter
wrote:

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe





--

Dave Peterson
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Can not do Add-Ins in Excel

Ron - No Disabled Add-Ins
Dave - Ran "repair" to no avail. Still do not have an xlb file.

Thanks for your comments. Let's hold off a bit. Our "computer guys" put the
installation files on my c-drive for ease of installation. To rule out these
file being bad, I'm going to get the actual cd(s) and uninstall and reinstall.

Send message soon, and again, THANKS!

Joe

"Dave Peterson" wrote:

If you make a change (however trivial), you'll recreate the *.xlb file.

(I don't have a guess about the real problem, though.)

Did you try Help|detect and repair? Or maybe reinstalling?




Joseph A. Carter wrote:

Okay, found and got rid of Excel11.xlb. Still no luck (add-ins don't work).

Excel did not create a new xlb file even after rebooting the computer.

"Gord Dibben" wrote:

Joseph

You "will" have an *.xlb file.

Also in Folder OptionsView uncheck "hide extensions for known file types"


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 07:47:00 -0800, Joseph A. Carter
wrote:

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe





--

Dave Peterson

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Can not do Add-Ins in Excel

If you make a change (however trivial), you'll recreate the *.xlb file.

That means a change to the toolbar.

Joseph A. Carter wrote:

Ron - No Disabled Add-Ins
Dave - Ran "repair" to no avail. Still do not have an xlb file.

Thanks for your comments. Let's hold off a bit. Our "computer guys" put the
installation files on my c-drive for ease of installation. To rule out these
file being bad, I'm going to get the actual cd(s) and uninstall and reinstall.

Send message soon, and again, THANKS!

Joe

"Dave Peterson" wrote:

If you make a change (however trivial), you'll recreate the *.xlb file.

(I don't have a guess about the real problem, though.)

Did you try Help|detect and repair? Or maybe reinstalling?




Joseph A. Carter wrote:

Okay, found and got rid of Excel11.xlb. Still no luck (add-ins don't work).

Excel did not create a new xlb file even after rebooting the computer.

"Gord Dibben" wrote:

Joseph

You "will" have an *.xlb file.

Also in Folder OptionsView uncheck "hide extensions for known file types"


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 07:47:00 -0800, Joseph A. Carter
wrote:

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe





--

Dave Peterson


--

Dave Peterson
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Can not do Add-Ins in Excel

GOT IT FIXED!

Uninstalled and reinstalled with the CDs, don't know if that helped.

I believe it was the Morefunc add-in. I just got a computer upgrade. With
the new computer, I went online and downloaded the latest Morefunc for my new
Excel. I believe this was the culprit and even after uninstalling morefunc,
the add-ins were still down.

Finally to fix it, I went to a colleague's computer and copied his files
into my "C:\Program Files\Microsoft Office\OFFICE11\Library". Rebooted and it
worked.

For future reference, the bad morefunc is the Setup.exe dated March 6th, 2006.

Joe

"Dave Peterson" wrote:

If you make a change (however trivial), you'll recreate the *.xlb file.


That means a change to the toolbar.

Joseph A. Carter wrote:

Ron - No Disabled Add-Ins
Dave - Ran "repair" to no avail. Still do not have an xlb file.

Thanks for your comments. Let's hold off a bit. Our "computer guys" put the
installation files on my c-drive for ease of installation. To rule out these
file being bad, I'm going to get the actual cd(s) and uninstall and reinstall.

Send message soon, and again, THANKS!

Joe

"Dave Peterson" wrote:

If you make a change (however trivial), you'll recreate the *.xlb file.

(I don't have a guess about the real problem, though.)

Did you try Help|detect and repair? Or maybe reinstalling?




Joseph A. Carter wrote:

Okay, found and got rid of Excel11.xlb. Still no luck (add-ins don't work).

Excel did not create a new xlb file even after rebooting the computer.

"Gord Dibben" wrote:

Joseph

You "will" have an *.xlb file.

Also in Folder OptionsView uncheck "hide extensions for known file types"


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 07:47:00 -0800, Joseph A. Carter
wrote:

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe





--

Dave Peterson


--

Dave Peterson



  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Can not do Add-Ins in Excel

Thanks for posting back. Google has it and maybe it'll help someone later.

Joseph A. Carter wrote:

GOT IT FIXED!

Uninstalled and reinstalled with the CDs, don't know if that helped.

I believe it was the Morefunc add-in. I just got a computer upgrade. With
the new computer, I went online and downloaded the latest Morefunc for my new
Excel. I believe this was the culprit and even after uninstalling morefunc,
the add-ins were still down.

Finally to fix it, I went to a colleague's computer and copied his files
into my "C:\Program Files\Microsoft Office\OFFICE11\Library". Rebooted and it
worked.

For future reference, the bad morefunc is the Setup.exe dated March 6th, 2006.

Joe

"Dave Peterson" wrote:

If you make a change (however trivial), you'll recreate the *.xlb file.


That means a change to the toolbar.

Joseph A. Carter wrote:

Ron - No Disabled Add-Ins
Dave - Ran "repair" to no avail. Still do not have an xlb file.

Thanks for your comments. Let's hold off a bit. Our "computer guys" put the
installation files on my c-drive for ease of installation. To rule out these
file being bad, I'm going to get the actual cd(s) and uninstall and reinstall.

Send message soon, and again, THANKS!

Joe

"Dave Peterson" wrote:

If you make a change (however trivial), you'll recreate the *.xlb file.

(I don't have a guess about the real problem, though.)

Did you try Help|detect and repair? Or maybe reinstalling?




Joseph A. Carter wrote:

Okay, found and got rid of Excel11.xlb. Still no luck (add-ins don't work).

Excel did not create a new xlb file even after rebooting the computer.

"Gord Dibben" wrote:

Joseph

You "will" have an *.xlb file.

Also in Folder OptionsView uncheck "hide extensions for known file types"


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 07:47:00 -0800, Joseph A. Carter
wrote:

Ron,
Thanks for trying, but I couldn't find an XLB file. Used using windows
explorer with options/view/show hidden files. Even went to someone elses
computer and couldn't find it there either.

Joe

"Ron de Bruin" wrote:

Hi Joseph

I think I try this first
Post back if it is not working after that


Reason: Maybe you have a corrupt or bloated xlb file *normal* size is < 30
kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Joseph A. Carter" <Joseph A. wrote in
message ...
When I pick "Tools", then "Add-Ins" in Excel (part of Office 2003), Excel
quits. I get:
"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience."

It then asks if I want to "Recover and restart Misrosoft Office Excel."

Any information would be much appreciated.

Thanks,

Joe





--

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
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 docs not saving as excel docs Beth Excel Discussion (Misc queries) 6 September 12th 06 02:39 AM
Open Excel 2003 from Windows Explorer pmpjr Excel Discussion (Misc queries) 9 September 11th 06 03:58 PM
Need suggestions for some uses of Ms Excel Bible John Excel Discussion (Misc queries) 1 February 27th 06 05:30 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


All times are GMT +1. The time now is 09:36 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"