Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |