how do I limit the number of rows when exporting data into excel?

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

WHEN I EXPORT FROM QUICKBOOKS, THE WORKSHEET OPENS WITH THE 65,540 ROWS.
This creates issues when manipulating the worksheet columns.
 
How does the number of "rows" create issues for manipulating "columns"?
Please explain.
 
Apparently this is why the excel locks up when I attempt to delete a column,
there are two may rows. If I start a new workbook, without an export from
Quickbooks, I do not have this issue.
 
Still not sure I understand your dilemna but I think you're export is filling
all 65,000+ rows in the excel sheet, right. One possible solution would be
to upgrade to Excel 2007. It has 1,048,576 rows which is a lot! But if that
is not possible, you'll probably have to break your export in to groups, like
fiscal years, or fiscal quarters if a year is too much. Something like that.
HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I increase the number of columns in a report? 1
how do i make more columns visible in a spreadsheet? 1
Excel help please, Button to export data 6
Import & Export 1
lookup data in a different workbook 1
Maximum number of rows exported from Outlook? 1
Exporting From Quickbooks-not formatting numbers 1
export data between excel files 1

Back
Top