XL2BB makes Excel crash with this file

felixstraube

Well-known Member
Joined
Nov 27, 2023
Messages
897
Office Version
  1. 365
Platform
  1. Windows
  2. Web
Hi dear MrExcel team.
I wanted to bring to your attention what i believe is a bug in the XL2BB add-on.
Today I was working on a file to help a forum user with some data validation. When I hit the MiniSheet button on the Xl2bb tab, excel freezed (excel not responding). I waited for a while to see if it would recover, but after a few minutes I closed the program and got this error:

1726231873518.png


The file i was working on you can download here: Lighting Workbook v2.zip

I don't know what this error message means exactly. I had some of these in another file, but it didn't freeze excel.
Maybe there is something you can change in the XL2BB code to avoid the freezing in these scenarios?

Best regards
 
Some of your named ranges consist of entire row or column, like PREMADE and many others.
XL2BB considers these named ranges as not properly set and doesn't work with them. It is not a bug.
 
That's not te issue if only we would get a message telling that those named ranges are not considered. The issue is that it freezes excel. At least for me. Or would it recover if I waited a very long time?
 

Forum statistics

Threads
1,226,453
Messages
6,191,134
Members
453,642
Latest member
jefals

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