XL2BB Disappears when Excel is Reopened

I'm not exactly sure where you are at now but if you carefully follow the steps listed here and at this step

1590827113248.png


XL2BB appears in the Add-Ins list for example like this

1590827199200.png


make sure that you carefully note the location (it will be different to what I have shown) then continue following the steps in the link above.

When you get to download the Add-In again, extract the xlam file and move it to somewhere you will know (Not a 'temp' folder I would suggest. Maybe even make your own Add-Ins folder, or use a location like the one shown above), unblock it if the properties show that is possible then proceed as per the instructions in the linked page.
 
Thanks. As I said in my post above I cannot delete as the X is unresponsive.
Though i tried to remove or change name that too was unsuccessful.
Can I use Extract all to delete and, if so , are there any things I should look out for
Thanks again
 
Have you deselected XL2BB in this dialog?

1590828677234.png
 
Finally I think I have done it.
After rebooting (thanks) I downloaded from site and it took me to the 5/4/20 modification in Temp .
When I browsed I could not find it in the Temp file for some reason.
So I went to the Download arrow at top of screen and right clicked and it took me to the file at bottom of Temp (??) why i dont know.
So I copied file and pasted to desktop.
After browsing from Add in Screen and selecting desktop shortcut Mr Excel came up on excel sheet.
Whether it remains ??
 
Update.
When I closed down and reopened Mr Excel had disappeared again.
In frustration I right clicked on the desktop icon and selected Properties.
In the Attributes section at bottom I ticked Unblock and hey presto Mr Excel reappeared.
Closed Excel sheet again and reopened and all good.
Thanks Peter_ss for your help
 
pedro-egoli said:
.. selected Properties.
In the Attributes section at bottom I ticked Unblock ...
Click to expand...
I did mention that before ;)
Peter_SSs said:
.. download the Add-In again, extract the xlam file and move it to somewhere you will know ... unblock it if the properties show that is possible ....
Click to expand...

.. and of course in the very first post in this thread
Peter_SSs said:
If this happens to you, try these steps:
  • Close Excel
  • Find the Add-In file in Windows File Explorer
  • Right click - Properties
  • On the 'General' tab, is there an 'Unblock' box at the bottom?
  • If so, tick that box then click OK
  • Reopen Excel
Click to expand...
Anyway, let's hope it is all sorted now. (y)
 
It was what probably prompted my old mind.
Thanks again:mad:
 
Hi to evryone!! I am facing the same issue!!! Originally i run the add-in from the Downloads file. Then i moved it together with the rest add ins in the C:\Users\User\AppData\Roaming\Microsoft\AddIns folder. Now everytime Excel is opened i get the following message
xl2bb_1.png


i click ok i open excel i go to Add in s menu and i get this
xl2bb_2.png



i then go to add-ins i delete it and then i re open it from the C:\Users\User\AppData\Roaming\Microsoft\AddIns folder.
xl2bb_3.png

xl2bb_4.png


But every time i open Excel its always connected to the downloads file...i followed the tips about the general tab in properties but i cant find any unticked box whatsever...any other suggestions?

Thank you in advance
 
Have you said Yes to the message and re-browsed for the file in the Addins folder? you could also try putting the Addin in the XLSTART folder.
 
You must log in or register to reply here.

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top