XLBB issue on PC

[bbbb1234]

I get this error when attempting to add the XLBB AddIn

Here is the PC Config

OS: Microsoft Windows 10 Home​

Version: 10.0.19044 Build 19044​

Excel & Office version: Microsoft 365​

Any ideas on how to fix this?

 

[smozgur]

I assume that you followed the installation steps already.
As it is also suggested in the error message, did you check if the file is still saved in M:\a-restore\Software XLBB for MrExcel.com\x2bb\xl2bb.xlam?
Note: Although it is not the reason of this error, if this location where you saved the add-in file is not in your trusted locations, then you might have additional restrictions with the add-in related with the security settings. See Microsoft's Trusted Location support page for more info.

 

[bbbb1234]

Smozgur - Thanks for the insight. The folder where the addin was located indeed was not a trusted location. All fixed!!!

 

[smozgur]

Smozgur - Thanks for the insight. The folder where the addin was located indeed was not a trusted location. All fixed!!!

 

[rickert91]

Do I have to disable my Macro before I can send the file. When I click on Mini Sheet, it spins, excel becomes unresponsive and have to restart excel

 

[smozgur]

No, macros should be enabled.

Is it also happening with only Cell Formulas selected?

Also, if it still doesn't work, then can you try it in a new worksheet without any conditional formatting and data validation, but a simple range with basic data?

 

[rickert91]

LATESTS AND GREATEST INVENTORY.xlsm
	A	B	C	D	E	F	G	H
1	TABLE OF CONTENTS
2	CATERING II
3	27-Apr-23
4	Sort order	Supplier name	Item #	Description	On hand Qty	Req Qty	Reorder	Available to order
5	1	EDWARD DON	1178232	FORK HW 6" COMPOSTABLE WOOD	2	2	0	Yes
6	2	EDWARD DON	1158972	FORK 6-1/2" WOOD	2	2	0	Yes
7	3	EDWARD DON	1202263	FORK 6-1/2" BAMBOO NATURAL	2	2	0	Yes
8	4	EDWARD DON	1187234	KNIFE HW 6" COMPOSTABLE WOOD	2	2	0	Yes
9	5	EDWARD DON+B5:D29B5:D27B5:DB5:D29	1158973	KNIFE 6-1/2" WOOD	1	2	1	Yes
10	6	EDWARD DON	1187233	SPOON HW 6" COMPOSTABLE WOOD	0	2	2	Yes
11	7	EDWARD DON	1158982	SPOON 6-1/2" WOOD	1	2	1	Yes
12	8	EDWARD DON	1158980	PLATE SQR 7X7"	1	2	1	Yes
13	9	EDWARD DON	1158978	PLATE SQR 10X10"	2	2	0	Yes
14	10	SYSCO ARKANSAS	4977601	STIRRER WOOD COFF 7.5 WRPD	1	1	0	Yes
15	12	SYSCO ARKANSAS	1155730	FORK PLAS PP WHT MED WT	1	2	1	Yes
16	13	SYSCO ARKANSAS	1155769	KNIFE PLAS PP WHT MED WT	0	2	2	Yes
17	14	SYSCO ARKANSAS	1161821	SPOON PLAS PP WHT MED WT	0	2	2	Yes
18	16	SYSCO ARKANSAS	7989207	FORK PLAS BLK HVY FULL LNGTH	2	2	0	Yes
19	17	SYSCO ARKANSAS	8202644	KNIFE PLAS BLK HVY FULL LENGTH	2	2	0	Yes
20	18	SYSCO ARKANSAS	8170122	SPOON PLAS BLK HVY FULL LENGTH	2	2	0	Yes
21	19	SYSCO ARKANSAS	2915799	KIT CUTLERY F/S/K/NAP WHT MED	6	6	0	Yes
22	20	EDWARD DON	1178897	PAN DEEP 1/3 SZ 5 LB CAP	1	2	1	Yes
23	21	SYSCO ARKANSAS	7465969	PAN FOIL STM TBL DEEPXH 2-9/16	2	2	0	Yes
24	22	SYSCO ARKANSAS	6938211	LID FOIL F/ HALF STMTBL PAN	4	3	-1	Yes
25	23	SYSCO ARKANSAS	7293283	PAN FOIL STM TBL FULL DP 3-3/8	2	2	0	Yes
26	24	SYSCO ARKANSAS	7293257	LID FOIL F/FULL STM TBL PAN	0	2	2	Yes
27	25	SYSCO ARKANSAS	7332592	PAN FOIL RND W/BOARD LID	1	2	1	Yes
28	26	EDWARD DON	1103926	LID BOARD F/ 9" RND CONTAINER	2	2	0	Yes
29	27	SYSCO ARKANSAS	7461401	PAN FOIL RND W/LAM BRD LID	1	2	1	Yes
CATERING II

Cell Formulas
Range	Formula
A3	A3	=TODAY()
G6:G29	G6	=F6-E6

 

[rickert91]

LATESTS AND GREATEST INVENTORY.xlsm
	B	C	D	E
1	TABLE OF CONTENTS
2	CATERING II ORDER
3	4/27/2023
4	SUPPLIER	ITEM NUMBER	DESCRIPTION	QTY TO ORDER
5	EDWARD DON	1158973	KNIFE 6-1/2" WOOD	1
6	EDWARD DON	1187233	SPOON HW 6" COMPOSTABLE WOOD	2
7	EDWARD DON	1158982	SPOON 6-1/2" WOOD	1
8	EDWARD DON	1158980	PLATE SQR 7X7"	1
9	SYSCO ARKANSAS	1155730	FORK PLAS PP WHT MED WT	1
10	SYSCO ARKANSAS	1155769	KNIFE PLAS PP WHT MED WT	2
11	SYSCO ARKANSAS	1161821	SPOON PLAS PP WHT MED WT	2
12	EDWARD DON	1178897	PAN DEEP 1/3 SZ 5 LB CAP	1
13	SYSCO ARKANSAS	7293257	LID FOIL F/FULL STM TBL PAN	2
14	SYSCO ARKANSAS	7332592	PAN FOIL RND W/BOARD LID	1
15	SYSCO ARKANSAS	7461401	PAN FOIL RND W/LAM BRD LID	1
16	EDWARD DON	1004957	TRAY CATER RND 12" BLK	2
17	EDWARD DON	1056427	LID DOME 18" PET CLR	2
18	EDWARD DON	1107711	TRAY CATER RND THERMOFORMED 18" BLK DON	2
19	EDWARD DON	1214577	CONTAINER DELI 8 OZ RND PP CLEAR W/LID	2
20	SYSCO ARKANSAS	7790795	LID PLAS CLR F/1.5-2.5OZ PRTN	1
21	SYSCO ARKANSAS	7790658	CUP PLAS PORTION BLK 2 OZ	2
22	SYSCO ARKANSAS	7064593	CUP PLAS HIPS TRANS PRTN 3.25Z	2
23	SYSCO ARKANSAS	3189372	CUP PORTION PLAS TRANS 4OZ	2
CATERING II ORDER

Cell Formulas
Range	Formula
B3	B3	=TODAY()

 

[rickert91]

I am trying to take certain cells from the CATERING II workbook to CATERING II ORDER with just selected ROWS B, C, D, G from the CATERING II TO CATERING II ORDER based on qty greater than 0

 

[Peter_SSs]

I am trying to take certain cells from the CATERING II workbook to CATERING II ORDER with just selected ROWS B, C, D, G from the CATERING II TO CATERING II ORDER based on qty greater than 0

Now that you have XL2BB working, you will need to ask your question & post your sample data in the Excel Questions forum.