XL2BB Error

[JimH]

I uninstalled xl2bb. I restarted Excel and copied xl2bb.xlam directly into the XLSTART folder. Tried it again and still got the error. Just to experiment I decided to check and uncheck the various boxes in the Additional Info section. When I unchecked Cond. Formatting, it worked. Go figure.

 

[smozgur]

Glad you solved it, and thanks for letting me know.

It is obviously something about the cells with conditional formatting. Unfortunately, I will never know what exactly caused that as I can't reproduce the same error with the same workbook even in the exact same environment.

 

[GSILVA66]

I download and extracted om my Win 10, but when I open Excel it wont show. I go to File. options, Add Ins and it has a check mark on it. Any suggestions is really appreciated.

 

[starl]

I download and extracted om my Win 10, but when I open Excel it wont show. I go to File. options, Add Ins and it has a check mark on it. Any suggestions is really appreciated.

Right-click on the file itself, go to Properties and make sure the file isn't blocked (If you see the Unblock checkbox at the bottom, check it, click OK)

See this post for other ideas: XL2BB Disappears when Excel is Reopened

 

[GSILVA66]

Right-click on the file itself, go to Properties and make sure the file isn't blocked (If you see the Unblock checkbox at the bottom, check it, click OK)

See this post for other ideas: XL2BB Disappears when Excel is Reopened

Hi, thank you for your response, I checked properties it looks ok, and all permissions are set to full control. I even placed it at the path...>Appdata>Roaming>Microsoft>Addins and still does not work. when I open Excel its not there, however when I check Fie, options down to Add ins it has a check mark.
I am trying to post a mini sheet to my post to see if anyone can help me figure out a Formula.

 

[smozgur]

@GSILVA66 - Can you try installing it by using the XLSTART folder method explained in the descriptions: XL2BB - Excel Range to BBCode?

You'll need to remove it from the add-ins before doing this or reinstalling by using any method. Uncheck the box. (I believe, by the way, as soon as you uncheck the box, Excel will claim that it cannot find the add-in and suggest to remove it from the list).

 

[GSILVA66]

@GSILVA66 - Can you try installing it by using the XLSTART folder method explained in the descriptions: XL2BB - Excel Range to BBCode?

You'll need to remove it from the add-ins before doing this or reinstalling by using any method. Uncheck the box. (I believe, by the way, as soon as you uncheck the box, Excel will claim that it cannot find the add-in and suggest to remove it from the list).

I already removed it. I also had an issue with office 365 in my Win 10 PC, I end uninstalling it completely, and reinstalling again. Still The Formula I am trying to create won't work.
Every other formula in the workbook, is fine. Only one that gives me trouble. Any other way I can upload a screenshot to my post, to see if someone can help me figure it out?
Thanks.

 

[smozgur]

Any other way I can upload a screenshot to my post, to see if someone can help me figure it out?

Although it is not functional like XL2BB, you can take a screenshot and paste it in the editor directly.

However, I strongly recommend also sending your formula as text, so it could be copied easily. Just copy and paste the formula into the editor, select it in the editor and click on the XLS button on the toolbar.

It will generate the following look, so it could be read and copied easily.

=IF($A1="a",1,2)

 

[GSILVA66]

NEW FEE TUITION COLLECTION VANGUARD.xlsx
	J	K	L	M	N	O	P
8	= IFERROR(IF(($D$4-E8)=0, 0, ($D$4-E8)),JAN!E8-F8)
FEB

 

[GSILVA66]

Something don't look right. I am new to MrExcel, and I am a beginner in excel, I apologize for not knowing how to post my question correctly.