XL2BB Disappears when Excel is Reopened

[Peter_SSs]

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.

 

[Marcelo Branco]

Thank you Peter,

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

M.

 

[Peter_SSs]

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]

Same same. Thanks Peter

 

[pedro-egoli]

I am having trouble with the

 

[pedro-egoli]

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]

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’)

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]

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
	A	B
17	ACCOUNT NO	29/05/2020
18	316	$2,939
19	1720	$5,816
20	147	$2,055
21	6344	$43
22		$10,853
SUMMARY

Cell Formulas
Range	Formula
B17	B17	=TODAY()
B22	B22	=SUM(B18:B21)

I will keep an eye on it and get back in need.
Thanks for your help

 

[Peter_SSs]

Cheers, Glad you got it going again.

 

[pedro-egoli]

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

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