Exports too many rows

Exporting a report with 100 rows gives me 65,000 rows in Excel worksheet. How do I prevent that?

Reply to
Richard
Loading thread data ...

You mean rows and not columns right?

Every blank Excel worksheet has 65536 rows. Don't believe me? Open a blank sheet, highlight the first column and type a shift return to go to the bottom.

If it really is an export problem, I suspect you may have to reload either Excel or Quickbooks. I've never seen data show up in cells where it doesn't belong. Otherwise I suspect you have a Excel question and you'll get better answers in an Excel group.

Reply to
Golden California Girls

All of my worksheets have 1,048,576 rows but who's counting.

Reply to
Haskel LaPort

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.