XL2BB Error

[JimH]

The first time I used xl2bb it worked great. I was going to post another question using the mini sheet, and I now get an 1004 - Application-defined or object-defined error.

 

[smozgur]

Hi Jim,

What's the platform (OS) and Office version?

Note: I suggest that you update your Account details (or 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’)

 

[JimH]

I run Windows 7 Professional 64-bit and Microsoft Office Professional 2010.

 

[smozgur]

I run Windows 7 Professional 64-bit and Microsoft Office Professional 2010.

Thanks. (Also thanks for updating your profile).

Is it happening for all workbooks or only a specific workbook/worksheet/range?
If a specific workbook, then do you consider sharing the workbook with me for testing purposes? (I will start a conversation with you if you'd like to send the workbook).

 

[JimH]

I've only tried it on this particular workbook. The workbook contains three worksheets one of which is currently empty. When I select a range of cells in either worksheet and press Table Only, I get the Mini-sheet successfully saved in the clipboard message. It is when I press Mini Sheet that I get the 1004 error message.

I can certainly send you the workbook if you think that would help.

 

[smozgur]

Thanks for the workbook.

I tested the workbook on Windows 7 64 bit, Office 2010, and it works as it is supposed to be.

-- Mini sheets removed

Obviously, it fails if I select the image on the worksheet prior to executing the XL2BB action but I don't think it is relevant.

Is it possible to test it with another workbook? Maybe a new workbook with some sample data in it? If it still fails on another workbook then I would ask you to try to delete the existing XL2BB add-in and reinstalling it. I am not sure if it would help but sometimes it does.

Thank you.

 

[JimH]

Hmm...it works fine on other workbooks.

 

[smozgur]

So it is related to the workbook. I wish I was able to reproduce it but even with the same OS and Office version, it doesn't happen at my side. Thanks for testing all these.

Is there a specific range that you are selecting on the current workbook?
Let's say you selected a blank cell and clicked on the Mini-sheet button. Does it still fail?

 

[JimH]

It works fine outside the table on both worksheets. Maybe I should uninstall and reinstall. What is the process to do thorough uninstall?

 

[smozgur]

If it works in other workbooks, in fact, if it works in the same workbook on a different range, then I don't think reinstalling the add-in would solve the issue. It sounds like that it is related to the range that you are selecting. However, what doesn't make sense is that it is not generating any error in my tests in the same environment. I am basically selecting a range in the tables, and it works without a problem.

Could it be possible to do the following final tests?
1- Copy one of the tables.
2- Create a new workbook, and paste the copied table into the worksheet in the new workbook.
3- Close the actual workbook.
4- Select the range in the table, or the entire table and run the XL2BB.

Another test by copying the worksheet to a new workbook.
1- Right-click on the worksheet tab on one of the worksheets that contain data in the actual workbook.
2- Click to Move or Copy..., select "new book" in the drop-down and click Create a copy option, then click Ok.
3- Close the actual workbook.
4- Try to create a mini-sheet.

With these two tests, I am trying to remove the parent workbook from the game to find out if there is a named range, dynamic range, or validation range causing the problem.
(Of course, it still doesn't explain how it works without problems in my computer, but that's all I can do for testing)

Thanks.