The problem is unlikely to have anything to do with the data. It is quite possible that an empty workbook, or one with a few lines of "typical" but not "actual" or "live" data would suffice.

What we need, to help you, is to see the code in context.