XL2BB Disappears when Excel is Reopened

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
63,549
Office Version
  1. 365
Platform
  1. Windows
If this happens to you, try one of these options:

Option A:
  • 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
Option B:
An alternative to the above steps is to ensure that the Add-In file is in a 'Trusted Location' & then the status of the 'Unblock' checkbox should be irrelevant.
 
Last edited:
Thank you Peter,

I was having this problem. Now everything is working perfectly!

M.
 
Thank you Peter,

I was having this problem. Now everything is working perfectly!

M.
You're welcome Marcelo. It will take a while to get most of the bugs ironed out and for us to get used to just how the new forum works. :)
 
Same same. Thanks Peter
 
I am having trouble with the
1590737234534.png
 
Not sure what happened with my preamble.
i had the same problem of xl2bb going missing after i used it.
Followed instructions and deleted from add-ins however, in trying to reinstall could not get file to open.T
The above screenshot is the properies.
I am a bit lost here and any help appreciated
 
i had the same problem of xl2bb going missing after i used it.
So you are saying that you were able to successfully use XL2BB and now you cannot? When (approximately) did you last use it successfully?

What version of Excel are you using and what operating system? Please update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

1590744205882.png


BTW, I have removed your other identical question as we do not want to have two sets of people trying to deal with the same issue - per rule #12 of the Forum Rules
 
So you are saying that you were able to successfully use XL2BB and now you cannot? When (approximately) did you last use it successfully?

What version of Excel are you using and what operating system? Please update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

View attachment 15027

BTW, I have removed your other identical question as we do not want to have two sets of people trying to deal with the same issue - per rule #12 of the Forum Rules
Sorry about the double pos.
have updated account details Am using excel 2016 and win 10
Used xl2bb here How to recognize a blank cell as zero
Then Mr Excel disappeared off my Excel sheets
Since posting I reloaded as an add in and hopefully this works below
Account balances for centrelink Final Version-1.xlsm
AB
17ACCOUNT NO29/05/2020
18316$2,939
191720$5,816
20147$2,055
216344$43
22$10,853
SUMMARY
Cell Formulas
RangeFormula
B17B17=TODAY()
B22B22=SUM(B18:B21)

I will keep an eye on it and get back in need.
Thanks for your help
 
Cheers, Glad you got it going again. (y)
 
Spoke to soon.
When i opened excel Mr Excel had disappeared and I ran into the same problem outlined here Message when excel opened
I deleted from Add-in and that solved that problem
However in trying to track down where xl2bb was I searched in my Temp files to find location
1590788541748.png

I see that this file was initially downloaded 5/4/20 so where I thought I had deleted previous version I had not.
Now I find that when I try and delete the delete X in home is unresponsive.
I can extract but am not sure what the outcome will be so any guidance on how to get rid of this file prior to reinstalling xl2bb appreciated
 

Forum statistics

Threads
1,212,931
Messages
6,110,745
Members
448,295
Latest member
Uzair Tahir Khan

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