View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default how do I limit the number of rows when exporting data into exc

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

"Donna" wrote:

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.

"Mike H." wrote:

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

"Donna" wrote:

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