Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.
increase excel rows to over 65 536
Name: chappr1000 Date: February 10, 2005 at 02:13:38 Pacific OS: NT/excel CPU/Ram: 512MB
Comment:
Hi there
I am trying to increase the number of rows in excel to over the limit of 65 536. Is this possible? If so how can I do it?
Name: wizard-fred Date: February 10, 2005 at 05:55:12 Pacific
Reply:
At this point maybe you need a little restructuring and migrate the information into a database (Access, SQL, etc.). You probably are no longer doing global recalculations. Also opening and saving will be faster.
0
Response Number 2
Name: StuartS Date: February 10, 2005 at 21:55:53 Pacific
Reply:
I doubt it very much. 65,536 is the maximum absolute value of a 32 bit number.
Summary: Excel row height problem using sort. I have a Excel work sheet the rows are of various size. Most are 20 high, some are 30 high. Now if I do a sort the size of the cell is not kept with the cell so I ...
Summary: hi all, one of my client computer containing outlook express not supporting excel rows and columns when i am copying any excel documents in outlook.how to solve this?thanks in advance. ...
Summary: Hi, I am new to the macros & programs I have a excel 2007 file, in that there are 43 rows, on 43rd row the total comes, now i want a seperate row & total row i.e. only 2 rows to be visible & other nee...
0 
unable to open tiff
