Home Page link  

Exports too many rows

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Exports too many rows Richard 04-26-2008
Posted by Richard on April 26, 2008, 12:25 pm
Please log in for more thread options
 Exporting a report with 100 rows gives me 65,000 rows in Excel
worksheet. How do I prevent that?

Posted by Golden California Girls on April 26, 2008, 3:57 pm
Please log in for more thread options
 Richard wrote:
> 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.





Posted by Haskel LaPort on April 27, 2008, 4:08 am
Please log in for more thread options

> Richard wrote:
>> 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.


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


>
> 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.
>
>
>
>



Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap