PDA

View Full Version : Excel Question

J-girl
10-06-2006, 05:19 PM
IS there a limit as to how many rows I can add on one Excel spreadsheet. Right now I have in the ballpark of 65,000, I need to add 10,000 more?

Thanks.
J-girl
10-06-2006, 05:22 PM
Bump! I know this will get buried
embrassezla
10-06-2006, 05:28 PM
Maximum worksheet size is 65,536 rows by 256 columns (for 2003 Excel).
pisces2473
10-06-2006, 05:32 PM
Holy shit, emb...I can't believe you know that!
embrassezla
10-06-2006, 05:35 PM
LOL pisces..we do a LOT of Excel-ing in my office. Uuuuuuuunfortunately. :)
J-girl
10-06-2006, 05:54 PM
Damn that shit froze my computer. I was trying to consolidate two files to make one pivot table.

TGIF!
MollyMe
10-06-2006, 08:33 PM
Can you use Access?
yankeeyosh
10-06-2006, 08:58 PM
All you have to do to figure it out is go to the bottom, which is Row No. 65,536, and then go to the right, which is Column IV (There are 26 letters, and after 'Z', we go to 'AA', 'AB', 'AC', etc...26*9 ('A' through 'HZ', or nine alphabets) + 22 (what 'V' stands for) = 256.

Can you use Access?

Access really isn't useful for calculations...however, one could easily append two Excel sheets into Access if that individual needs to query.
spokes
10-07-2006, 01:33 AM
pivot tables ae alright, but sometime an array is much more flexible.
J-girl
10-07-2006, 01:06 PM
Hmmn maybe I should play around with arrays more.

Molly- I dont have access.
spokes
10-09-2006, 01:27 AM
Hmmn maybe I should play around with arrays more.

omg - that is so hot...............what are you going to be wearing.... :huge: