XL2BB Issue with table with formula.

[HighAndWilder]

I am not sure if this issue should be raised elsewhere so please advise me if that is the case.

I have a sheet with one table with formula in many of the columns.

I highlight the table and select the Mini Sheet XL2BB option.

I get a error 6 Overflow error message.

The table contains formula but these are not included in the XL2BB code if I select the Table Only option.

Short of submitting VBA code that creates and populates a table how can I submit a table with formula in a post.

Thanks

 

[smozgur]

@HighAndWilder: I got your file. Thanks for letting me analyze it.

Could you please check the named ranges in the workbook. I think you might have selected the entire worksheet to change the font but entered Arial into the name box. Therefore, it is considered as a named range (which is already the case) and XL2BB is failing due to the huge named range. If you delete the Arial named range, then everything should work without problems.