| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I limit the number of rows when exporting data into excel?
WHEN I EXPORT FROM QUICKBOOKS, THE WORKSHEET OPENS WITH THE 65,540 ROWS.
This creates issues when manipulating the worksheet columns. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I limit the number of rows when exporting data into excel?
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I limit the number of rows when exporting data into exc
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I limit the Number of rows in an excel 2007 workbook | Setting up and Configuration of Excel | |||
| Is there a limit to the number of rows in a excel spread sheet ? | Excel Discussion (Misc queries) | |||
| How do I increase the limit on the number of import rows in Excel | Excel Discussion (Misc queries) | |||
| How to limit number of rows Excel? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Linear Mode
