Exporting a report with 100 rows gives me 65,000 rows in Excel worksheet. How do I prevent that?
Exports too many rows
Apr 26, 2008
2 Replies
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.
All of my worksheets have 1,048,576 rows but who's counting.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required