Accounting Talk Accounting Talk    FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Exports too many rows          Accounting Talk Forum Index -> Quickbooks View previous topic :: View next topic   Author Message Richard Guest Posted: Sat Apr 26, 2008 4:25 pm    Post subject: Exports too many rows Exporting a report with 100 rows gives me 65,000 rows in Excel worksheet. How do I prevent that? Back to top   Ads Advertising Sponsor Golden California Girls Guest Posted: Sun Apr 27, 2008 12:57 am    Post subject: Re: Exports too many rows Richard wrote: Quote: 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. Back to top   Ads Advertising Sponsor Haskel LaPort Guest Posted: Sun Apr 27, 2008 11:00 am    Post subject: Re: Exports too many rows "Golden California Girls" <gldncagrls@aol.com.mil> wrote in message news:mOLQj.284$lc6.224@trnddc04... Quote: 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. Quote: 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. Back to top   Ads Advertising Sponsor Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         Accounting Talk Forum Index -> Quickbooks All times are GMT Page 1 of 1   Jump to: Select a forum Accounting Talk----------------Accounting TalkPeachtreeQuickbooksQuicken  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum 68 Attacks blocked Powered by phpBB © 2001, 2005 phpBB Group