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

D

Donna

WHEN I EXPORT FROM QUICKBOOKS, THE WORKSHEET OPENS WITH THE 65,540 ROWS.
This creates issues when manipulating the worksheet columns.
 
M

Mike H.

How does the number of "rows" create issues for manipulating "columns"?
Please explain.
 
D

Donna

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

Mike H.

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
 

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
Naming a Data Range 2
How to limit number of rows and column in worksheet? 1
how do i combine excel worksheets 1
VBA - retrieve data on last create named range from previous inserted named range 0
How do I combine data (not consolidate) from separate tabs to one? 2
My Excel file is not calculating! 13
limit the scroll of a worksheet 2

Top