XL2BB Disappears when Excel is Reopened

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,446
Office Version
365
Platform
Windows
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
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:

Some videos you may like

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,446
Office Version
365
Platform
Windows
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. :)
 

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,493
Office Version
365, 2010
Platform
Windows
Same same. Thanks Peter
 

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,144
Office Version
2016
Platform
Windows
I am having trouble with the
1590737234534.png
 

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,144
Office Version
2016
Platform
Windows
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
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,446
Office Version
365
Platform
Windows
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
 

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,144
Office Version
2016
Platform
Windows
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 NO
29/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
 

pedro-egoli

Well-known Member
Joined
Apr 25, 2004
Messages
1,144
Office Version
2016
Platform
Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,874
Messages
5,446,999
Members
405,426
Latest member
Nasty15

This Week's Hot Topics

Top