Exporting a report with 100 rows gives me 65,000 rows in Excel worksheet. How do I prevent that?
- posted
15 years ago
Exporting a report with 100 rows gives me 65,000 rows in Excel worksheet. How do I prevent that?
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.
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.