smozgur

XL2BB - Excel Range to BBCode 2.1

No permission to download

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
I do not mean the thread but I mean the addon itself
It would be an unnecessary feature that will make the add-on be considered as an application communicating on the internet in the background and cause additional security concerns. Therefore, no, the add-on doesn't check the new version online. As I mentioned, since you downloaded the add-on here, you'll be notified as soon as a new version is released.
 
It would be an unnecessary feature that will make the add-on be considered as an application communicating on the internet in the background and cause additional security concerns. Therefore, no, the add-on doesn't check the new version online. As I mentioned, since you downloaded the add-on here, you'll be notified as soon as a new version is released.
Thanks mate.
 
Hi, I tried to copy a range to paste in a post, and get this error:

1626235355940.png



When copying the range (with filters applied), Excel just hung for an eternity and provided this error when I tried to close the program.

I'm using Excel 365. Below is a screenshot of what I was trying to copy. The cell containing "11" in red has this formula in it:
Excel Formula:
=SUMPRODUCT(SUMIFS($C$11:$C$20,$A$11:$A$20,B$3,$B$11:$B$20,IF(SUBTOTAL(3,OFFSET($A$4,ROW($A$4:$A$8)-ROW($A$4),0,1,1)),$A$4:$A$8,"")))

(Same for the "12" in red).

Thanks

1626235421475.png
 
Hi, I tried to copy a range to paste in a post, and get this error:

Please ignore! I searched online and saw suggestions to copy my table into a brand new workbook. So I did that, and it worked!

I can't seem to delete/edit my previous post. Hopefully anyone experiencing the same issue will see this post to see how to resolve.
 
Please ignore! I searched online and saw suggestions to copy my table into a brand new workbook. So I did that, and it worked!

I can't seem to delete/edit my previous post. Hopefully anyone experiencing the same issue will see this post to see how to resolve.
@junbuggle - thanks for reporting the issue, even you found the workaround.

Still, I am very much interested to find out what was causing the error in the original workbook. If the workbook doesn't contain any sensitive data, then I wonder if you could share it with me, so I can analyze it to see if I can find the reason for the failure and possibly avoid it to happen?

Please let me know if you could, then I will send you a conversation message to get the workbook.

Thanks.
 
@junbuggle - thanks for reporting the issue, even you found the workaround.

Still, I am very much interested to find out what was causing the error in the original workbook. If the workbook doesn't contain any sensitive data, then I wonder if you could share it with me, so I can analyze it to see if I can find the reason for the failure and possibly avoid it to happen?

Please let me know if you could, then I will send you a conversation message to get the workbook.

Thanks.

Hi, the workbook does contain sensitive info, I'm afraid.

That being said, I'm happy to do some testing or answer questions if that helps? Perhaps we could do that over PM.
 
My XL2BB tab shows up in the ribbon at the end. I can copy ranges. However I cannot customize it in the ribbon to move it around. It is unblocked. Any ideas?
 

Forum statistics

Threads
1,223,247
Messages
6,171,004
Members
452,374
Latest member
keccles

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