| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More than 65,536 lines
Excel 97. Any way to get more than 65,536 lines on a worksheet?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
More than 65,536 lines
The number of lines in XL 97-2003 is fixed at 64K. There is no way to
increase this. XL 2007 has 1 million rows. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 3 Dec 2008 14:53:29 -0800 (PST), Fan924 wrote: Excel 97. Any way to get more than 65,536 lines on a worksheet? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
More than 65,536 lines
On Dec 4, 9:53*am, Fan924 wrote:
Excel 97. Any way to get more than 65,536 lines on a worksheet? Congratulations! You've pushed Excel to it's limit. Yeah, we've all hit that wall from time to time. I had one application where I ended up importing my data into ACCESS, then sorting it and doing some pre-work to get it down to below 65500 lines. I don't know if your data is flexible enough for that. Otherwise, Excel 2007 is your next call. 1,000,000 rows with 16384 columns! Woohoo! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
More than 65,536 lines
1,000,000 rows with 16384 columns! Woohoo! Has anyone ever needed more than 368 columns? (One leap year with header and sum :-) Number of rows, however, should be infinitve - you can never get rows enough! CE |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
| inserted lines move how to place lines in proper cell? | Excel Worksheet Functions | |||
| Sub to copy only result lines within formula range, omit null string lines | Excel Programming | |||
| Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
| excel97 vba to append lines to text file overwriting last 2 lines | Excel Programming | |||
Linear Mode
